E | F | G |
Target | Status (Days) | Actual |
3/15/2019 | 33 | 4/17/2019 |
4/1/2019 | FALSE | 3/22/2019 |
4/18/2019 |
<tbody>
</tbody>
Here is the function I'm using:
=IF(G6>=E6, TODAY()-E6), IF(G6<=E6, DATEDIF(E6,G6,"d")) but can't figure out how to work
My calc cells are above
Basically I need it to calculate the Past Due #of days if the Actual is after the target,
if the actual falls before the target then count the #of days ahead of schedule
if the actual is empty then say something like "In Progress"