IFERROR being strange :(

[Gary687]

I want to add the IFERROR function to the formula:

=($AA$1-C6)/365

So that if an error appears, it will say "Invalid hire date" (this formula is used to calculate the length of time employees have been working at a company.)

I tried =IFERROR($AA$1-C6)/365,"Invalid hire date") but I need to add another parenthesis...

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[ashishmehra2010]

Hi,

Try this: =IFERROR(($AA$1-C6)/365,"Invalid hire date")

Regards,
AM

[Gary687]

Thank you again TMS
Thank you as well Ashish!