Calculate every Monday
Hello How do I calculate the date for every Monday in the year 2007?
thanks |
Answer: Calculate every Monday
To calculate every Monday in the year 2007, you can use the following steps:
Alternatively, you can use the "AutoFill" feature in Excel to quickly fill in the dates for every Monday in the year 2007. Here's how:
|
Calculate every Monday
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 |
Calculate every Monday
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 |
Calculate every Monday
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) -- Don Guillett SalesAid Software "Wanna Learn" wrote in message ... Hello How do I calculate the date for every Monday in the year 2007? thanks |
Calculate every Monday
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 "Wanna Learn" wrote in message ... | Hello How do I calculate the date for every Monday in the year 2007? | thanks |
Calculate every Monday
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. -- David Biddulph "Wanna Learn" wrote in message ... Hello How do I calculate the date for every Monday in the year 2007? thanks |
Calculate every Monday
Thanks Everyone.......
"David Biddulph" wrote: 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. -- David Biddulph "Wanna Learn" wrote in message ... Hello How do I calculate the date for every Monday in the year 2007? thanks |
All times are GMT +1. The time now is 02:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com