View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nmorse
 
Posts: n/a
Default 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()
--------------------