Help with Datedif based on certain conditions...

[Leechmil]

Sorry for being a total noob but I'm trying to do something and it's totally
throwing me!

Basically I want to take a date contained in cell H4 and compare it to todays date,

then work out the difference between the two in days, this is working ok using the

datedif function...

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

However if cell H4 is blank or the date contained in H4 is above todays date it displays #NUM! - is there anyway to hide this?

Thanks in advance for any help!

 

[SteveO59L]

=if(iserror(DATEDIF(H4,TODAY(),"d")),"Something Wrong",DATEDIF(H4,TODAY(),"d") )

 

[Leechmil]

Steve, thanks for your super-fast reply, much appreciated! that formula worked perfectly but now I presented with another minor problem!

Basically if the cell H9 mentioned previously contains no date then the output cell automatically displays 39315 days!

 

[SteveO59L]

=if(iserror(DATEDIF(H4,TODAY(),"d")),"Something Wrong",if(h4>0,DATEDIF(H4,TODAY(),"d"),"Date Missing") )

 

[Aladin Akyurek]

Sorry for being a total noob but I'm trying to do something and it's totally
throwing me!

Basically I want to take a date contained in cell H4 and compare it to todays date,

then work out the difference between the two in days, this is working ok using the

datedif function...

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

However if cell H4 is blank or the date contained in H4 is above todays date it displays #NUM! - is there anyway to hide this?

Thanks in advance for any help!

=IF(H4,DATEDIF(H4,TODAY(),"d"),"")

 

[Leechmil]

Thanks for your help guys, works perfectly now!