| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding second-to-last workday of month
I am trying to find the second-to-last workday of every month for 2010.
So far, I have =DATE(YEAR(A1),MONTH(A1)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),2)-5)) but just returns the last workday. I have tried to modify to find the second to last workday. Any ideas? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count the number of workday in a month | Excel Worksheet Functions | |||
| Compare & sum previous month production by workday. | Excel Discussion (Misc queries) | |||
| workday with month functions | Excel Worksheet Functions | |||
| finding the last day of the month | Excel Discussion (Misc queries) | |||
| Excel inventory Sheet for workday month | Excel Worksheet Functions | |||
Threaded Mode
