Date of the first Sunday every month

M

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
 
P

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
 
M

Mark Graesser

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
[email protected]
Boston M

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

Take a look here

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