Invalid data type for Date Formula

Hello,

I am trying to figure out what I am doing wrong. I keep getting invalid data type and I am not sure why, the source column and formula column are both set to date columns.

Here is the formula I am using, =WORKDAY([Date January Late Notification Sent]@row, 10), I am trying to figure out 10 working days from the date listed in the "Date January Late Notification Sent" Column, which is set as a date column in properties.

Find more posts tagged with

Accepted answers

JamesB

@CaraBart28 Try putting a date in your Date January Late Notification Sent cell. Since your formula has no data to reference it errors out.

you could do this.

=IFERROR(WORKDAY([Date January Late Notification Sent]@row, 10)," ")

All comments

JamesB

@CaraBart28 Try putting a date in your Date January Late Notification Sent cell. Since your formula has no data to reference it errors out.

you could do this.

=IFERROR(WORKDAY([Date January Late Notification Sent]@row, 10)," ")

CaraBart28

@JamesB adding in the IFERROR worked, thank you so much!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.