# "Week Starting" date from created date

Options
✭✭✭✭✭

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

Andrea Zenner

Program Manager | Infrastructure & Operations

Apogee Enterprises

EAP | Mobilizer | Core Product Certified | Superstar

azenner@apog.com

Tags:

## Best Answers

• ✭✭✭✭✭✭
Answer ✓
Options

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

• ✭✭✭✭✭
Answer ✓
Options

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

## Answers

• ✭✭✭✭✭✭
Answer ✓
Options

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

• ✭✭✭✭✭
Answer ✓
Options

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

• ✭✭✭✭✭
Options

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

Andrea

Andrea Zenner

Program Manager | Infrastructure & Operations

Apogee Enterprises

EAP | Mobilizer | Core Product Certified | Superstar

azenner@apog.com

• ✭✭✭✭✭
Options

@Jon Mark H that works too! 😊

Andrea Zenner

Program Manager | Infrastructure & Operations

Apogee Enterprises

EAP | Mobilizer | Core Product Certified | Superstar

azenner@apog.com

• ✭✭✭✭✭
Options

Glad to help!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!