Inserting dates in a worksheet

M

Mrtimj

I am running Excel 97. I am trying to automate an attendance workshee
and would like to have it insert the correct dates in the appropriat
cells. Example, all of the Sundays in January.
What would be the best way to do this? Any help would be highl
appreciated! Thanks!

Ti
 
S

Simon Lloyd

Tim not entirely sure what your trying to do here, can you give a bette
explanation or example?

Simo
 
B

Bob Phillips

Put this formula in A1

=DATE(2004,1,1)+((7-WEEKDAY(DATE(2004,1,1))+1)*(WEEKDAY(DATE(2004,1,1))<>1))

and this in A2 and copy down

=A1+7

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top