Error code for date formula

Kelly Ospina

Good morning,

I'm hoping someone can help me with this formula (formulas are not my strongest area, can you tell? Yikes!). I need to count the number of days between two approval dates.

This is the formula: =ABS([Mgr Approval Date]@row - [Exec Approval Date]@row)

It works, unless one of the date columns is blank.

I've tried ISERROR and ISDATE, but I'm not doing something right it keeps throwing up error codes.

Thanks so much!

Bassam Khalil

Hi @Kelly Ospina

Hope you are fine, please try the following formula.

=IFERROR(ABS([Mgr Approval Date]@row - [Exec Approval Date]@row), "")

Bassam Khalil

Hi @Kelly Ospina

Hope you are fine, please try the following formula.

=IFERROR(ABS([Mgr Approval Date]@row - [Exec Approval Date]@row), "")

Kelly Ospina

Wonderful! Thank you so much!

Bassam Khalil

@Kelly Ospina

You are welcome and I will be happy to help you any time. Please help the Community by marking it as an ( Accepted Answer)