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...
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?