In Numbers, I am wanting to list the Tuesdays (at 4:30 pm) and Fridays (at 2:30 pm) as part of
a calendar, for the next 9 months. i.e. First column is the month, next is the date (either a Tuesday or a Friday),
next is the event that I want to list, etc.
What I wonder is, if there is an AI command that I can do to ask this program to set that out.
OR, is there another AI program where I can fine those dates in that order.
Thank you,
Tom
I am wanting to automatically list dates in a certain order with particular dates and times of the month.
The why is to minimize my time to look up all those dates for 9 months.
—–
Tom Daily
First, I wouldn't put the date in one column and the time in another. Both would be time values and it would be confusing and awkward to separate them. The date would one like June 3 12:00 a.m. and the second would be a duration of 16 hours and 30 minutes. It would be very difficult to deal with those values and there's no good reason to do so.
So I would have one column with the date (like 6/3/2025 4:30:00 pm) and the other column with the event.
So in A2 put: 6/3/2025 4:30 pm
In A3 put: 6/6/2025 2:30 pm
Then in A4 put a formula that adds a week to the date from two rows before it. So =A2+DURATION(1,0)
You can add duration values to date values. So you can add 5 hours or 2 days or 1 week. In this case DURATION(1,0) is 1 week, 0 days.
So now copy and paste A4 into A5 and below as you like. It will just repeat what is above, adding a week. So you get Tuesdays and Fridays repeating with those specific times.
I hope that fits your needs. You didn't really answer the WHY question so I'm not sure. You never said WHY you need to know the dates or Tuesdays and Fridays. Couldn't just using the Calendar app have done the same thing?
The reason I am not using Calendar is that I want to use a spreadsheet and enter other things in columns. The reason why is to create a calendar for play rehearsals and performances for a play group that I direct. I don't need all the dates, just those when rehearsals and performances are listed. Thank you, Tom