Find the Monday for a week that a date falls into
Where A2 is the field with the date.
The great thing is that
- It works across year breaks and you don’t end up with Week 53
- It fits with SQL – date_trunc(‘week’, Date) – functions so you can correctly match Excel data