Date function

  • Thread starter Thread starter Charles
  • Start date Start date
C

Charles

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!!
 
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
 
Back
Top