Only Show Dates between a defined start date and End Date

trish123

New Member
Joined
Apr 6, 2016
Messages
48
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 ?? :confused:
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Watch MrExcel Video

Forum statistics

Threads
1,109,275
Messages
5,527,721
Members
409,784
Latest member
AdamPriest

This Week's Hot Topics

Top