Date formula not adding days

Jenn Burk · 2022-06-23T14:22:17+00:00

There was an error rendering this rich post.

Jenn Burk

I'm trying to add "days" to a Date.

The formula in the "Test" column is:

=[Ex Works]@row + (IFERROR(INDEX({business days}, MATCH(Location@row, {location}, 0)), ""))

This is the error that I'm getting. I'm not sure what I'm doing wrong.

Find more posts tagged with

Formulas

Accepted answers

Alan P.

You're welcome :)

Alan P.

I was able to get it to work.

Made sure the first column was a 'Date' column (Used the second column)
'Test' column must be a 'Date' column as well
Add this formula to your 'Test' column: =[Ex Works]@row + [Business Days]@row

I hope this helps

All comments

Alan P.

You're welcome :)

Jenn Burk

OMG! I had the "Test" column as text, not a date.

I can't believe that I didn't see that.

Thank you so much!!!!

Alan P.

I was able to get it to work.

Made sure the first column was a 'Date' column (Used the second column)
'Test' column must be a 'Date' column as well
Add this formula to your 'Test' column: =[Ex Works]@row + [Business Days]@row

I hope this helps

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.