# How do I convert a date to Monday's date within its week?

S

#### Sorsy

How do I convert a date (from cell A1) to Monday's date within its week into
cell B1?

T

#### T. Valko

One way:

=1-WEEKDAY(A1,2)+A1

M

#### Mike H

Try this in b1

=IF(WEEKDAY(A1)=1,A1-6,A1-(WEEKDAY(A1)-2))

Mike

R

#### Ron Rosenfeld

How do I convert a date (from cell A1) to Monday's date within its week into
cell B1?

What is the first day of the week?

If the first day is Monday, then:

=A1+1-WEEKDAY(A1+6)

If the first day is Sunday, (so the Monday would be the day after Sunday) then:

=A1+2-WEEKDAY(A1)
--ron

S

#### Sorsy

This really helps, I learn something new. Thanks!

S

#### Sorsy

This really helps. Thanks!

Ron Rosenfeld said:
What is the first day of the week?

If the first day is Monday, then:

=A1+1-WEEKDAY(A1+6)

If the first day is Sunday, (so the Monday would be the day after Sunday) then:

=A1+2-WEEKDAY(A1)
--ron

S

#### Sorsy

This really helps. Thanks!

T. Valko said:
One way:

=1-WEEKDAY(A1,2)+A1