Week Commencing Date

Maxine Roberts · 10/16/20

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?

Ramzi K · 10/19/20

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 K · 10/19/20

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

Maxine Roberts · 11/02/20

@Ramzi K Thank you for your help :)

stuartr · 01/29/24

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

Best Answer