Nested OR statement with Workday function

I have two columns that populate dates, if one has a date in it the other one is empty. I'm trying to develop a formula that looks at both columns and returns the day of the week.

=IF(OR(WEEKDAY([Meeting Date]@row) = 2, WEEKDAY([Due Date]@row) = 2), "Monday", "") and I'm getting an #INVALIDDATATYPE error message. I've worked the formulas by themselves and they work but the minute I combine them it populates the error.

Find more posts tagged with

Accepted answers

Paul Newcome

Try nesting the IF inside of the WEEKDAY function.

WEEKDAY(IF([Meeting Date]@row <> "", [Meeting Date]@row, [Due Date]@row))

All comments

Paul Newcome

Try nesting the IF inside of the WEEKDAY function.

WEEKDAY(IF([Meeting Date]@row <> "", [Meeting Date]@row, [Due Date]@row))

Rayme

Thanks! I knew I was overlooking something simple!

Paul Newcome

Happy to help. 👍️

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.