Date function

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!!
 
T

Tyro

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
 

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

Similar Threads

Finding the right function & formula 4
Looking for a formula 3
Counting dates but excluding weekends 3
Countif Function?? 3
Deriving an earlier date based on a later date 7
Inverse to WEEKNUM 8
Change colour based on date 6
Last workday 2

Top