Date of the first Sunday every month

[Maria]

Hi

I need to list the dates of the first Sunday of every
month.
Is there a way to use the fill handle? I've tried
putting in the two dates below each other, it's working
out the difference between the two but it's not picking
up that it's the first Sunday.

Many thanks

Maria

 

[JE McGimpsey]

Take a look here:

http://cpearson.com/excel/DateTimeWS.htm#NthDoWYear

 

[Peo Sjoblom]

Assume you put the year in A1 (assume 2004) , in A2 put this formula and
copy down
to A13

=DATE($A$1, ROW(1:1),1)+6-WEEKDAY(DATE($A$1, ROW(1:1), 1),3)

will give you first Sundays for 2004

01/04/04
02/01/04
03/07/04
04/04/04
05/02/04
06/06/04
07/04/04
08/01/04
09/05/04
10/03/04
11/07/04
12/05/04

 

[Guest]

Hi Maria
Here's a quick modification of Chip's First Weekday of Month formula

=DATE(YEAR(A1),MONTH(A1),1)+CHOOSE(WEEKDAY(DATE(YEAR(A1),MONTH(A1),1)),0,6,5,4,3,2,1

This will give you the first Sunday of each month. A1 should contain any date within the month. You can apply a custom number format of mmm of mmmm to these cells to diplay the month in text

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- JE McGimpsey wrote: ----

Take a look here

http://cpearson.com/excel/DateTimeWS.htm#NthDoWYea