Only Show Dates between a defined start date and End Date

[trish123]

HI there,
Can someone help, i have a problem where i have the 4 columns consisting of an Estimated Start Date (C19) and End date(D19) and Actual Start Date(F19) and End date(G19) for different project functions.

I am sorted for the the start of point here i have in Cell J16 =DAY(F19+1) which i have dragged all the way over the corresponding columns which only shows Monday to Friday to my estimated end date

What I am looking for is a solution be it VBA code/a conditional formatting if this is even an option/If Statement etc.. where my Gannt Chart only shows up to the Actual End Date and if not the Estimated End Date??

Any Ideas and help greatly appreciated ??

 

[XLfriend777]

Hi trish123 - I'm not exactly sure of the details of your question, but to help get started ExcellsFun (Mike Girvin) did a great video on Gantt Charts in excel that can be accessed here. https://www.youtube.com/watch?v=qaisZI6i75U