DATEDIF Formulas

[mikeywhits]

Hi all,

I currently have the following formula (below) which calculates the number of days between the cell A1 and TODAY, though if the date in cell A1 has not occurred yet the text #NUM! appears.

What i would like to do is if the date has not occured then instead of #NUM! I would like this to be 0. is this possible?

=DATEDIF(I3,TODAY(),"d")

Thanks.

 

[VoG]

Try

=IF(I3>TODAY(),0,DATEDIF(I3,TODAY(),"d"))

 

[jasonb75]

Maybe

=MAX(0,TODAY()-I3)

 

[mikeywhits]

Thanks guys went for the =IF(I3>TODAY(),0,DATEDIF(I3,TODAY(),"d")), works perfectly