![]() |
Generate list of dates for 4-week periods
I work with 4-week periods that start on Mondays. Is it possible to input a
start date, a term and have a list generated of all the dates that start every 4 weeks. i.e. Start date is 1/5/09 for 3 terms (12 weeks), the list of dates would be 1/5/09, 2/2/09, & 3/2/09. The variable are the start date and term. Thanks in advance for your help! Karie |
Generate list of dates for 4-week periods
If the first date is in A2, the date 4 weeks on from there is =A2+28.
(There are 28 days in 4 weeks.) -- David Biddulph Karie wrote: I work with 4-week periods that start on Mondays. Is it possible to input a start date, a term and have a list generated of all the dates that start every 4 weeks. i.e. Start date is 1/5/09 for 3 terms (12 weeks), the list of dates would be 1/5/09, 2/2/09, & 3/2/09. The variable are the start date and term. Thanks in advance for your help! Karie |
All times are GMT +1. The time now is 04:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com