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