software

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()
--------------------

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 Sjoblomquot;nmorsequot; gt; wrote in
message ...
gt;
gt; So, I thought I had this down - but started up the file today only to
gt; find that the date is a week off... I don't know why - it was fine all
gt; last week.
gt;
gt; Here's the formula I have currently:
gt;
gt;
gt; Code:
gt; --------------------
gt; =B2 (WEEKDAY(B2)=N2)*7-WEEKDAY(B2) N2
gt; --------------------
gt;
gt;
gt; Where N2 is the number 2 (for Monday) and B2 is
gt; Code:
gt; --------------------
gt; today()
gt; --------------------
gt; .
gt;
gt; What I'm trying to get it to do is, based on B2, say that this
gt; particular log is for the entire week beginning Monday, March 27th.
gt; Then, on Monday April 3rd, it would turn to say quot;for the week beginning
gt; Monday April 3rdquot;, etc.
gt;
gt; Any ideas?
gt;
gt; Thanks.
gt;
gt;
gt; --
gt; nmorse
gt; ------------------------------------------------------------------------
gt; nmorse's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32875
gt; View this thread: www.excelforum.com/showthread...hreadid=526787
gt;

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: www.excelforum.com/member.php...oamp;userid=32875
View this thread: www.excelforum.com/showthread...hreadid=526787