| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I generate a list of random dates from dates I specify | Excel Worksheet Functions | |||
| List of Dates- Assign Week Number?? | Excel Discussion (Misc queries) | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| How do I combine a list of dates & a value into 1 week intervals | Excel Discussion (Misc queries) | |||
| How to generate a random list of weekDAYS between two dates? | Excel Worksheet Functions | |||
Linear Mode
