Date Formula for the Monday following a Date

I'm looking for a formula or automation that calculates the date of the Monday following a specific date. The initial date may be a Tuesday, Wednesday, or Thursday, but the date I need to "fill in" will always be Monday, as it's a due date. In the example below, the Schedules Due Date column needs to be the Monday after the date in the Confirmation Date. Any ideas? Thanks in advance!

Find more posts tagged with

Formulas

Accepted answers

All comments

Andrew1983

https://community.smartsheet.com/discussion/26476/automatically-populate-monday-before-existing-date-in-sheet

I actually just had the same issue, but I needed the previous monday.

=IF(ISDATE(Date@row), IF(WEEKDAY(Date@row) = 1, Date@row - 6, Date@row - WEEKDAY(Date@row) + 2))

Make sure your column property is set "DATE" or else you'll get an "invalid column value" error.

I was going to say you need two columns to do this but I see now you're using the "confirmation date" as your actual date and then you will have your calculated Monday date in your "schedules due" date.

Sandahllyn

How do you make this equation return the following Monday?

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.