Date In excel

[kumar lama]

=IF(M5="","On Service",DATEDIF(K5,L5,"y")&" Y, "&DATEDIF(K5,L5,"ym")&
" M, "&DATEDIF(K5,L5,"md")&" D")


If Blank It's Returning #NUM!, i dont want that i want Show "On Service"

What makes Error here?

Or Can make also =If(L5=date(anydate),DATEDIF(K5,L5,"y")&" Y, "&DATEDIF(K5,L5,"ym")&
" M, "&DATEDIF(K5,L5,"md")&" D"),"On Service"

But this aslo i dont know what to do in Date If(L5=date(anydate)

Thanks

 

[MARK858]

Are you sure M5 is truly blank, the formula works for me. The only way I get a NUM! error is if there is something in M5 and the dates are the wrong way round. Try testing with ISBLANK(M5).

Excel Workbook
	K	L	M	N	O	P
5	01/12/2013	12/07/2015			On Service	TRUE
6	01/12/2013	12/07/2015	2		1 Y, 7 M, 11 D	FALSE
7	12/07/2015	01/12/2013	1		#NUM!	FALSE
Sheet3

 

[kumar lama]

Thanks For help it's Worked, i figure out my Problem
MARK858