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

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

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

One way:

=1-WEEKDAY(A1,2)+A1

--
Biff
Microsoft Excel MVP


"Sorsy" wrote in message
...
How do I convert a date (from cell A1) to Monday's date within its week
into
cell B1?

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

Try this in b1

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

Mike

"Sorsy" wrote:

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

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

On Wed, 8 Oct 2008 13:10:01 -0700, Sorsy
wrote:

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

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

This really helps, I learn something new. Thanks!

"Mike H" wrote:

Try this in b1

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

Mike

"Sorsy" wrote:

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

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

This really helps. Thanks!

"T. Valko" wrote:

One way:

=1-WEEKDAY(A1,2)+A1

--
Biff
Microsoft Excel MVP


"Sorsy" wrote in message
...
How do I convert a date (from cell A1) to Monday's date within its week
into
cell B1?

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

This really helps. Thanks!

"Ron Rosenfeld" wrote:

On Wed, 8 Oct 2008 13:10:01 -0700, Sorsy
wrote:

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

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

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Sorsy" wrote in message
...
This really helps. Thanks!

"T. Valko" wrote:

One way:

=1-WEEKDAY(A1,2)+A1

--
Biff
Microsoft Excel MVP


"Sorsy" wrote in message
...
How do I convert a date (from cell A1) to Monday's date within its week
into
cell B1?