austenr
08-25-2010, 07:01 AM
Using this formula:
=DATEDIF(spdob,dor,"m")/12
where spdob = spouse date of birth
dor = date of retirement
if i dont enter a spdob the cell the formula is in returns 111. Is this a default? I need it to say 0 if no spdob is entered.
How can I correct this? Thanks
=DATEDIF(spdob,dor,"m")/12
where spdob = spouse date of birth
dor = date of retirement
if i dont enter a spdob the cell the formula is in returns 111. Is this a default? I need it to say 0 if no spdob is entered.
How can I correct this? Thanks