Solved: Formula take 2

[austenr]

Using this formula:

[vba]=DATEDIF(spdob,dor,"m")/12[/vba]

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

[Bob Phillips]

It takes the empty date as 1/1/1900, so the number of months will be however many from there until the dor date, which is 1327 to now.

[austenr]

ok, can i force it (the cell) to be zero if the first argumentof the datedif is blank?

[Bob Phillips]

It already assumes that.

[austenr]

I meant the formula the cell is in. Right now it shows 111, i want it to be zero if spdob is blank. Sorry.

[Bob Phillips]

Sorry, I see what you mean.

=IF(spdob="",0,DATEDIF(spdob,dor,"m")/12)

[austenr]

thanks Bob.