dateif formula

[OceanPlanet13X]

Hi all

My datedif formula is return #Num, ideally it should return a value £35 or £0 if date in h3 is less and equal to H5.


col h col j

02/08/2010 £35

01/10/2000 #NUM!
30/03/2002 #NUM!
02/05/2011 #NUM!


,=DATEDIF($H$3>=H5,J3,0)

Thanks in advance for any help

 

[barry houdini]

That doesn't look like a valid use of DATEDIF, I think you just need IF - try this

=IF(H$3>=H5,J$3,0)

 

[OceanPlanet13X]

Thanks Barry for quick reqly