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 presentin...
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?
- Good question,
For example, we have weeks timeline,
Suppose week one (all the 7 days) are in vacation table, but we included Friday & Saturday dates to include in the other table, so now Week 1 has two working days which are Friday & Saturday, for that, it should appear in the timeline just as week 1. If all the week 1 days are off days, week 1 will not appear and week 2 will appear first instead of week 1. Same goes for months too.
