| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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() -------------------- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| 4 and 5 week months | Excel Discussion (Misc queries) | |||
| Dates by week, formula | Excel Worksheet Functions | |||
| 4 Day Work Week in a formula | Excel Discussion (Misc queries) | |||
| Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
Threaded Mode
