Generate list of dates for 4-week periods

K

Karie

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
 
D

David Biddulph

If the first date is in A2, the date 4 weeks on from there is =A2+28.
(There are 28 days in 4 weeks.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top