# How do I Auto Populate a Calendar Series per Start and End Date?

1. ## How do I Auto Populate a Calendar Series per Start and End Date?

I am hoping I can get some help here. If you see on the attach spreadsheet.
I am wanting for the Calendar dates to automatically populate on another sheet.
If you look at the Sheet called Schedule and see Cell B3 & B4 for the Start and End Date.
I would like whatever dates I enter to be populated on Sheets called Internal, Operations, Executive & Customer.
I currently have a formula on the Internal Sheet, on Cell D3 and E3 that gives me the calendar scheduled by me having to copy the formula across, for it to function. But normally the customer working on this spreadsheet will get it blank as in the Operation sheet and once they enter the dates on Schedule sheet I would like for the calendar dates to automatically update on the sheets according to the start and end dates put on the Schedule Sheet, with a +7 date per Cell.

Hope this makes sense!! Thank you and look forward to your help.WW Working Book v1.4.xlsx

2. ## Re: How do I Auto Populate a Calendar Series per Start and End Date?

Put this formula in D3:

=IF(Schedule!\$B\$3="","",Schedule!\$B\$3)

and this one in E3:

=IF(OR(D3="",Schedule!\$B\$4=""),"",IF(D3+7<=Schedule!\$B\$4,D3+7,""))

Then copy E3 across as far as you need to (eg AZ3).

If there are no dates in B3 or B4 (or if B4 is less than B3, as you have it now), then the cells will appear blank. You can then copy this range range of cells into the other sheets, starting from D3.

Hope this helps.

Pete

3. ## Re: How do I Auto Populate a Calendar Series per Start and End Date?

I copied the as you mention but in Cell E3 the dates do not populate at all.
Cell D3 worked out fine.

Inez15

4. ## Re: How do I Auto Populate a Calendar Series per Start and End Date?

I got it to work - Thank you.
So the only way for this function would be to populate the formula far enough out so it captures enough dates depending on the length of the project.

Thank you so much Pete

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1