I'm trying to auto populate a column with Monday to Sunday dates based on date from another column.

tgattsh

Example "Current Date" Column "01/08/24" "Week Of" column would auto populate "01/08/24 - 01/14/24"

Current Date / Week Of

01/08/24 / 01/08/24 - 01/14/24

01/09/24 / 01/08/24 - 01/14/24

01/10/24 / 01/08/24 - 01/14/24

01/15/24 / 01/15/24 - 01/21/24

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Sorry about that. Had an errant piece still floating around.

=[Current Date]@row + (2 - WEEKDAY([Current Date]@row)) - IF(WEEKDAY([Current Date]@row) < 2, 7, 0) + " - " + ([Current Date]@row + (2 - WEEKDAY([Current Date]@row)) - IF(WEEKDAY([Current Date]@row) < 2, 7, 0) + 6)

All comments

Paul Newcome

Try this:

=[Current Date]@row + (2 - WEEKDAY([Current Date]@row)) - IF(WEEKDAY([Current Date]@row) < 2, 7, 0) + " - " + (=[Current Date]@row + (2 - WEEKDAY([Current Date]@row)) - IF(WEEKDAY([Current Date]@row) < 2, 7, 0) + 6)

tgattsh

@Paul Newcome Thank you so much for your reply! Unfortunately I get an #INVALID OPERATION.

Any further suggestions would be greatly appreciated sir...

Paul Newcome

Sorry about that. Had an errant piece still floating around.

tgattsh

To say AWESOME would be an understatement! Thank you @Paul Newcome ...

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