Help with IFERROR and DATEEDIF showing 117 instead of 0

Try this formula
=IF(OR(Today="",M17=""),0,DATEDIF(M17,Today,"y"))

Originally Posted by Syrkrasi

Try this formula
=IF(OR(Today="",M17=""),0,DATEDIF(M17,Today,"y"))

I am testing this out right now.

Ok, I have a data validation rule set to the column (sorry forgot to mention that) with the following parameter:

Whole Number

between

Minimum - 0
Maximum - 200

So when I use the above formula I get the error message "the value you entered...". I have checked and unchecked the ignore blank which hasn't helped.

I did this data validation because I was getting items entered that were not correct.

Originally Posted by rhett7660

... I have the following formula:

=IFERROR(DATEDIF(M17,TODAY,"y"),0)

This works great if there is date in M17, however I would like it to show a 0 if there is no date in M17 instead of the number 117. The column is formatted as a number...

Maybe

=IFERROR(DATEDIF(1/(1/M17),TODAY,"y"),0)

Originally Posted by Norie

Any chance you could upload a sample workbook?

Click on GO ADVANCED, scroll down and click Manage Attachments.

It looks like Root_ suggestion worked out.