Date function
 

I am looking for a date function that will return the Monday for the week in
which the given date is in. For example cell A1 has the date 2-13-2008 (a
Wednesday) I would like to have a function that would return 2-11-2008
(Monday). Any ideas?
Thanks in advance!!

Date function
 

=A1-WEEKDAY(A1)+2

Tyro

"Charles" wrote in message
...
I am looking for a date function that will return the Monday for the week
in
which the given date is in. For example cell A1 has the date 2-13-2008 (a
Wednesday) I would like to have a function that would return 2-11-2008
(Monday). Any ideas?
Thanks in advance!!

Date function
 

=A1-MOD(A1-2,7)


"Charles" wrote:

I am looking for a date function that will return the Monday for the week in
which the given date is in. For example cell A1 has the date 2-13-2008 (a
Wednesday) I would like to have a function that would return 2-11-2008
(Monday). Any ideas?
Thanks in advance!!

Date function
 

Your formula puts Sunday in the preceding week. In the U.S. Sunday is the
first day of the week. But, as I don't know where the OP is, I don't know
what the OP considers the week starting/ending day to be.

Tyro

"Teethless mama" wrote in message
...
=A1-MOD(A1-2,7)


"Charles" wrote:

I am looking for a date function that will return the Monday for the
week in
which the given date is in. For example cell A1 has the date 2-13-2008 (a
Wednesday) I would like to have a function that would return 2-11-2008
(Monday). Any ideas?
Thanks in advance!!