Forum Discussion
date timeline from start & end dates in excel
In this sheet, I would like to have a date timeline generated from 6 inputs:
1- start date ( where timeline should starts )
2- end date ( where timeline should ends )
3- data presenting type (days, weeks or months)
4- weekend type to be excluded from timeline ( Friday & Saturday, Saturday & Sunday or No Days off)
5- weekend days that would be included in timeline ( due to overtime for example )
6- vacations should be excluded from timeline ( if same date is in vacation table & weekend days to include in timeline table, dates should be included in timeline.
I tried achieving this through "if" function, but I couldn't, it goes messy! I only succeed in generating days timeline as shown in the image! is it possible to achieve that in excel 2016?
- I guess need to prepare a long list of whole 365 days of one year and then filter on this list.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
And what do you want to do with the data presenting type (days, weeks or months)?
Dear Mr. Hans, thank you for your respond,
for the presenting data type, I meant that, if I choose "Days", time line would appear as days dates, if I choose "Weeks", timeline should appear as "week 1 of the month", Week 2of the month" and so on.
I attached an example file to demonstrate the problem through this link:
https://drive.google.com/drive/folders/1GUut_8RTvaw0miPbSU-7oI_o1u8tz0sf?usp=sharing
How should we treat weekend dates, vacation dates and dates to include if the timeline should display weeks?
And how if the timeline should display months?
