Forum Discussion
Weekly Gantt Chart using IF AND statement
(Yes, I realize that MS Project would be the more appropriate tool.. Let's get that clear.. Political, budget and user constraints - enough said!). Attempting to create a very simple Gantt Chart i...
Hi Carter,
I guess your formula is incorrect. If, for example, we take one day Dec 03 or Dec 31, they both meet condition since BG4 is Dec 03 and BK4 is Dec 31.
For Nov 15 (F20 and G20) BD4 is >= F20, but BD4 is not <=G20 and the formula returns FALSE.