Forum Discussion
Can someone explain in layman's terms how this formula works?
Hi All, I've used this formula to develop a Gant Chart. The formula works perfectly, however, I get lost in trying to understand it. =IF(MONTH(C2-WEEKDAY((C2),2)+1)<MONTH(C2),(C2-28-DAY(C2)...
HansVogelaar firstly, thank you so much for your time and knowledge it makes it much clearer.
Secondly, you highlighted the mistake in January. How would I correct that?
Or, would there be an easier formula/function to insert to show the date?
Here is a corrected and slightly shorter formula:
=C2-DAY(C2)-WEEKDAY(C2-DAY(C2),3)+IF(MONTH(F2)<>MONTH(C2),-21,7)