Forum Discussion
Excel Formula to fill weekly calendar
Hoping to get help on attached excel doc: 1. I need column D to NOT include US weekends or holidays. 2. I need the cells in columns E - I to auto fill with green color based on the start and fini...
Hi Nora,
To return the correct end date for the projects wit zero duration
=WORKDAY($D4-($E4>0),$E4)
Conditional formatting I applied for wider range
=$J$4:$AZ$666
and adjust the rule formula to exclude empty dates
=($D4<=J$2+7)*($F4>=J$2)*($D4>1)
Works great now. I can't thank you enough. How kind of you Sergei to help a stranger. Wishing you blessings. Nora
Nora, you are welcome