M
MARION
I am trying to calculate the days that a student is in a
particular phase of training based on a today's date and
some phase start date.
However one particular phase's start date is in the future.
How can I get around the #num error. I have tried using
the IF function to 0 out the cell but it still cannot
handle the future date in the DATEIF function.
Start Date:1-APR-2005=M4
Today's Date:16-APR-2004=M3
IF(M4<M3,0,M5)
DATEIF(M4,M3,"YD")=M5 RESULTS IN #NUM ERROR
particular phase of training based on a today's date and
some phase start date.
However one particular phase's start date is in the future.
How can I get around the #num error. I have tried using
the IF function to 0 out the cell but it still cannot
handle the future date in the DATEIF function.
Start Date:1-APR-2005=M4
Today's Date:16-APR-2004=M3
IF(M4<M3,0,M5)
DATEIF(M4,M3,"YD")=M5 RESULTS IN #NUM ERROR