Error code for date formula

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!

Find more posts tagged with

Accepted answers

Bassam Khalil

Hi @Kelly Ospina

Hope you are fine, please try the following formula.

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

All comments

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)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.