I'm using Excel 2010.
If I have
TODAY() function on a cell (
cell2), it gives me this:
12/26/2012. I want to get Monday's date based on
cell2 date. In other words, in want this:
How can I do that?
migrated from stackoverflow.com Dec 27 '12 at 8:33
This question came from our site for professional and enthusiast programmers.
This should do it (although I don't have Excel handy so taking it from memory)
(where A1 is the cell containing the date)
Where A1 is today's date. This formula will return the Monday date of the week
if you want the previous Monday's date.