Dear Gurus,
Good Day.
I am building a Gantt Chart in excel using formula to generate the Gantt Chart outcome, but there is one logic in the if formula I could not figure out.
The logic that I am using is using IF function, compare start date and end date with the date in Gantt Chart header (date starting every first day of the month).
The problem that I am facing is if I compare the date of the Gantt Chart with the start and end date of the contract, some of the short term contract in the month will not be capture.
Below is the formula that I wrote:
IF(OR($T6="Dropped",$T6="Relocated"),"",IF(AND(Gantt Chart header date>=start date,Gantt Chart header date<=end date),$S6,""))
Would appreciate if any guru can help to sort out a formula that only compare month and year of between the dates.
Thank you.
Warmest Regards,
Eric
Bookmarks