I have an installation date column and a "week of" column. In our "week of" column, we keep the date of the Monday before.
As an example, if the installation date is 1/19/17, the "Week of" column should be 1/16/17. Or, if the date is on a Monday, (Installation 1/23/17), the "Week of" column should be the same as the installation column (Week of 1/23/17).
I need a formula that would allow me to just fill in the installation date, and will automatically populate the "Week of" date. Every formula I have tried fails when the date is a Monday, so if I filled in 1/23/17, it will populate the Monday prior (1/16/17).
Thanks!