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

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:
--------------------
=B2+(WEEKDAY(B2)=N2)*7-WEEKDAY(B2)+N2
--------------------


Where N2 is the number 2 (for Monday) and B2 is
Code:
--------------------
today()
--------------------

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

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?


--

Regards,

Peo Sjoblom


"nmorse" wrote in
message ...

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:
--------------------
=B2+(WEEKDAY(B2)=N2)*7-WEEKDAY(B2)+N2
--------------------


Where N2 is the number 2 (for Monday) and B2 is
Code:
--------------------
today()
--------------------
.

What I'm trying to get it to do is, based on B2, say that this
particular log is for the entire week beginning Monday, March 27th.
Then, on Monday April 3rd, it would turn to say "for the week beginning
Monday April 3rd", etc.

Any ideas?

Thanks.


--
nmorse
------------------------------------------------------------------------
nmorse's Profile:
http://www.excelforum.com/member.php...o&userid=32875
View this thread: http://www.excelforum.com/showthread...hreadid=526787

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

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.


--
nmorse
------------------------------------------------------------------------
nmorse's Profile: http://www.excelforum.com/member.php...o&userid=32875
View this thread: http://www.excelforum.com/showthread...hreadid=526787