Simple? Formula for "for the week starting Monday May Xxth"

N

nmorse

So, I thought I had this down - but started up the file today only to
find that the date is a week off... I don't know why - it was fine all
last week.

Here's the formula I have currently:


Code:
 
P

Peo Sjoblom

To find the current/next Monday

=TODAY()-WEEKDAY(TODAY()-2)+7

will return 03/27/06 today and tomorrow 04/03/06

If you want current/previous Monday

=TODAY()-WEEKDAY(TODAY()-1)+1

btw is there a reason you put today() in B2 and not directly in the formula?
 
N

nmorse

Thank you. I'll try that.

As for why I was calling it from B2 -- well, B2 is a today() formula,
so just thought I'd pull it from there... But this should work just
fine, I think.
 
Top