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:

=B2+(WEEKDAY(B2)=N2)*7-WEEKDAY(B2)+N2

Where N2 is the number 2 (for Monday) and B2 is

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.

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" <nmorse.25c6w0_1143477004.0797@excelforum-nospam.com> wrote in
message news:nmorse.25c6w0_1143477004.0797@excelforum-nospam.com...
>
> 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
>

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.