Calculated date that doesn't fall on weekend but next week day

I have a date field (Date to be Completed) where I calculate so many days before or after a "Course Launch Date". I need to make sure that if that calculation lands on a weekend it automatically advances to Monday. Here's the steps, just can't figure out the formula.

Course Launch Date: (PARENT): 5/26/20

Date to be Completed: =(PARENT([Course Launch Date]@row) + 12)

This formula results in a Sunday: How can I make it land on Monday if it's on a weekend? Or if needed - Land on Friday if it's Saturday and land on Monday if it's Sunday?

Thanks!!!

Find more posts tagged with

Accepted answers

Paul Newcome

You can use an IF statement for this along the lines of...

=date formula + IF(WEEKDAY(date formula) = 7, -1, IF(WEEKDAY(date formula) = 1, 1))

=PARENT([Course Launch Date]@row) + 12 + IF(WEEKDAY(PARENT([Course Launch Date]@row) + 12) = 7, -1, IF(WEEKDAY(PARENT([Course Launch Date]@row) + 12) = 1, 1))

All comments

Paul Newcome

You can use an IF statement for this along the lines of...

=date formula + IF(WEEKDAY(date formula) = 7, -1, IF(WEEKDAY(date formula) = 1, 1))

=PARENT([Course Launch Date]@row) + 12 + IF(WEEKDAY(PARENT([Course Launch Date]@row) + 12) = 7, -1, IF(WEEKDAY(PARENT([Course Launch Date]@row) + 12) = 1, 1))

Jeana

Yes!!! Thanks so much. Don't know why I couldn't come up with that formula.

Thanks so much!

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.