Hi,
I'm getting an error message (#NUM!) for the following formula and i'm not
sure why:
=IF(AD31="","",IF(DATEDIF(Z31,AD31,"m")=0,"",DATED IF(Z31,AD31,"m")))

where AD31 has a value of 07-01-05
and Z31 has a value of 97-04-23

This is a formula that i entered into the first row and then dragged the
formula down to apply to the other cells in this column. The formula is
working in most of the other cells.

I aslo got an error message (#VALUE!) for this same formula in a different
row:
=IF(AD74="","",IF(DATEDIF(Z74,AD74,"m")=0,"",DATED IF(Z74,AD74,"m")))

where AD74 is blank
and Z74 is 09-02-04

These two errors occur a couple of times throughout the spreadsheet, while
the rest of the cells with this formula are working fine.