Require solution to DATEDIF function

[kdr]

I use the DATEDIF function to calculate the number of days between two dates, when this formula runs accross text instead of dates (because dates aren't always required) I recieve a #VALUE! result.

Because the spreadsheet is so large (close to 2000 rows currently) I want to be able to click and drag the formula down and not have to remove it where text is present; I want the rows where text is present to result in a blank cell and rows that have two dates to calculate with to show the number.

If there is a better formula to use, that would be fine also

Thank you,

 

[MrKowz]

try:

=IF(OR(ISTEXT(ref1),ISTEXT(ref2)),"",*Datedif function*)

 

[shg]

If you're using Excel 2007+, =IFERROR(your datedif expression, "")

 

[barry houdini]

Hello kdr, welcome to MrExcel

Dates are simply formatted numbers in excel so you could perhaps check that the inputs are both numbers, something like

=IF(COUNT(A2,C2)=2,DATEDIF(A2,C2,"y"),"")

 

[kdr]

Thank you Barry Houdini, that formula worked wonders!