Calculate every Monday

[Wanna Learn]

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

 

[Ron Rosenfeld]

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

 

[MartinW]

Hi

You could put 01/01/2007 (which is a monday) in A1.
In A2 put =A1+7 and drag the formula down 53 rows.

HTH
Martin

 

[Don Guillett]

to calculate the first one from 1/1/2006 in cell b1. Then +7 for others.
=B1-DAY(B1)+8-WEEKDAY(B1-DAY(B1)+6)

 

[Niek Otten]

With the start date in A1 (1/1/2007):

In A2:
=A1+8-WEEKDAY(A1,2)
In A3:
=A2+7
Copy down as far as you need

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

 

[David Biddulph]

Either look up the date of the first Monday in 2007, or try the first 7 days
of 2007 and format as DDD to check, then with the first Monday in cell A1,
set cell A2 to =A1+7. Then copy A2 down for the next 51 rows.

 

[Wanna Learn]

Thanks Everyone.......

Either look up the date of the first Monday in 2007, or try the first 7 days
of 2007 and format as DDD to check, then with the first Monday in cell A1,
set cell A2 to =A1+7. Then copy A2 down for the next 51 rows.