Formula to calculate the previous & current week's date based on current week's Monday

Please help me with the formula to get the date and day under following condition:

If Today is Monday then it should reflect last week's date from Monday to Friday (date and day), if Today is anything other than Monday then it reflect current week date and day from Monday to Friday.

Currently I am using following formula:

=IF(WEEKDAY(Date1) = 1, Date1 - (WEEKDAY(Date1) - 2), Date1 - (WEEKDAY(Date1) - 2) + 0)

This formula changed every week

Find more posts tagged with

Accepted answers

All comments

Genevieve P.

Hi @sandeep kumar

Would you be able to explain what it is you're looking to do a little further?

When you say "date and day", what is it that you're looking to output? Is the screen capture above the example data you're looking at, or is it an example of what you want it to show?

The current formula will always show you that week's Monday Date. You can use the TODAY Function instead of referencing a Date Cell if that would help:

=IF(WEEKDAY(TODAY()) = 1, TODAY() - (WEEKDAY(TODAY()) - 2), TODAY() - (WEEKDAY(TODAY()) - 2) + 0)

Cheers,

Genevieve

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.