| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Determining the Sunday date of the third "full" weekend of a month
For a given month number (in column A) and year (in column B), I need to
determine the Sunday date of the third "full" weekend. A "full" weekend is defined as one in which a Saturday and Sunday occur within the same month (i.e., Saturday and Sunday do NOT straddle two months). For example, the Sunday date of the third "full" weekend in November 2009 is November 22, whereas the Sunday date of the third "full" weekend in December 2009 is December 20. I would greatly appreciate any help in coming up with the formula (and worksheet function) that will accurately and consistently determine the Sunday date of the third "full" weekend of a month. Thanks, Bob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert WEEKNUM(date;2) to text "Monday 25th - Sunday 31st Oct" | Excel Discussion (Misc queries) | |||
| counta & countblank for "month-to-date/year-to-date"? | New Users to Excel | |||
| Functions for "current" & "previous" month to calculate data | Excel Worksheet Functions | |||
| If date is in the month of Sept, then "1", otherwise "2" | Excel Worksheet Functions | |||
| "Disk is Full" add-on question to "Can't reset last cell" post tod | Excel Discussion (Misc queries) | |||
Threaded Mode
