On Thu, 2 Nov 2006 05:35:02 -0800, Wanna Learn
wrote:

Hello How do I calculate the date for every Monday in the year 2007?
thanks

First Monday in 2007:

A1: =DATE(2007,1,8)-WEEKDAY(DATE(2007,1,6))

Then for each subsequent Monday, merely add 7:

B1: =A1+7

Select B1 and copy/drag down as far as required.




--ron