| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Second Saturday Of The Month
=DATE(YEAR(A1),MONTH(A1),1+7*2)-WEEKDAY(DATE(YEAR(A1),MONTH(A1),8-7))
where A1 has any date in the month in question. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "FrankM" wrote in message ... OK, this may seem fairly simple but I'm missing something ... Is there a formula that will calculate the Second Calendar Saturday of the Month for me? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Last Saturday of the Year | Excel Discussion (Misc queries) | |||
| Help finding the date of the last Saturday of a given month | Excel Worksheet Functions | |||
| first saturday in a month | Excel Worksheet Functions | |||
| How to set Saturday as a working day | Setting up and Configuration of Excel | |||
| "Saturday as a work day? | Excel Worksheet Functions | |||
Hybrid Mode
