ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Generate list of dates for 4-week periods (https://www.excelbanter.com/excel-discussion-misc-queries/216184-generate-list-dates-4-week-periods.html)

Karie

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

David Biddulph[_2_]

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