DATEIF

[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

 

[Frank Kabel]

Hi
try
=IF(M4<M3,DATEDIF(M4,M3,"YD"),DATEDIF(M3,M4,"YD"))