"Week Starting" date from created date

Andrea Zenner

Hello Formula Gurus!

Do any of you have a formula that will return the "week starting" date based on a created date? So evaluate the created date of a row and bring back the date of Monday that week.

Thanks much,

Andrea

Leibel S

@Andrea Zenner

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

Jon Mark H

Here's what I got to work:

=Created@row + (2 - WEEKDAY(Created@row))

Where "Created" is the Created Date Column.

Let me know if you need any further assistance!

-Jon Mark

Leibel S

@Andrea Zenner

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

Jon Mark H

Here's what I got to work:

=Created@row + (2 - WEEKDAY(Created@row))

Where "Created" is the Created Date Column.

Let me know if you need any further assistance!

-Jon Mark

Andrea Zenner

@Leibel Shuchat Beautiful! Works exactly as I wanted. Thanks much!

Andrea

Andrea Zenner

@Jon Mark H that works too! 😊

Jon Mark H

Glad to help!

Jonathan_p_o_ITM

@Leibel Shuchat thanks for this!!!!