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...
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.
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.
I'll see if I can come up with something, but it's complicated.
- Sure!
Thank you so much for your reply & for you effort in advanced.The code in the attached workbook could be optimized, but please check whether it does what you want.
- It works perfectly!
Thank you so much sir,
You really helped me a lot, Im grateful and thankful for that!
May I use it for both my personal & my commercial uses ?
Thank you again!