I am trying to create a spreadsheet with all the dates of Sunday in one column. How can I go about doing this? I have tried by using DAYVALUE(1)
, but cant get that to return a date.
First, e.g. in Calendar, lookup the date of the first Sunday in January for the year you want to create the spreadsheet of Sundays in a year. For this example, lets use the first Sunday in January of 2017, i.e. January 1, 2017.
In Numbers, e.g.:
A1
to: Date
A2
to: January 1, 2017
A3
to: =A2+7
A3
down to: A54