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

--
Message posted from http://www.ExcelForum.com

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

Simo

--
Message posted from http://www.ExcelForum.com

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)

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

Tim


---
Message posted from http://www.ExcelForum.com/