# Week Commencing Date

Options
✭✭✭✭

Does anyone have a formula I could use to work out the week commencing date for a date field where Monday is the start of the week?

Tags:

## Best Answer

• ✭✭✭✭✭
Answer ✓
Options

Try this:

=[Your Date]@row - IF(WEEKDAY([Your Date]@row) = 2, 0, IF(WEEKDAY([Your Date]@row) = 1, 6, WEEKDAY([Your Date]@row) - 2))

Cheers,

Ramzi

Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)

Feel free to email me: ramzi@cedartreeconsulting.com

💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.

## Answers

• ✭✭✭✭✭
Answer ✓
Options

Try this:

=[Your Date]@row - IF(WEEKDAY([Your Date]@row) = 2, 0, IF(WEEKDAY([Your Date]@row) = 1, 6, WEEKDAY([Your Date]@row) - 2))

Cheers,

Ramzi

Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)

Feel free to email me: ramzi@cedartreeconsulting.com

💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.

• ✭✭✭✭
Options

@Ramzi K Thank you for your help :)

• ✭✭✭✭✭
Options

@Ramzi K thank you also. I just used your formula and it worked like a dream

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!