If cell is not blank, then return a date.

swirt009

Hi All,

I'm trying to write a formula where if an employee's "Initial Certification" was completed (so the "Initial Certification Completion Date" field will not blank), then the "1st Recertification Due Date" will be two years from the "Initial Certification Completion Date". This is what I have so far:

=IF(NOT(ISBLANK([Initial Certification Completion Date]@row), DATE(YEAR([Initial Certification Completion Date]@row) + 2, MONTH([Initial Certification Completion Date]@row), DAY([Initial Certification Completion Date]@row))

This returns "INCORRECT ARGUMENT SET"

Any ideas?

Thanks!

Mike TV

@swirt009

=IF(NOT(ISBLANK([Initial Certification Completion Date]@row)), DATE(YEAR([Initial Certification Completion Date]@row) + 2, MONTH([Initial Certification Completion Date]@row), DAY([Initial Certification Completion Date]@row)))

Mike TV

@swirt009

=IF(NOT(ISBLANK([Initial Certification Completion Date]@row)), DATE(YEAR([Initial Certification Completion Date]@row) + 2, MONTH([Initial Certification Completion Date]@row), DAY([Initial Certification Completion Date]@row)))

swirt009

Thank you, Mike!

That worked.