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?
 
Ad

Advertisements

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. 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
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top