Finding second-to-last workday of month

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

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!
 
If you are using XL2003 or earlier, you will need to have the Analysis
ToolPak add-in active...

=WORKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),-1)
 
=WORKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),-1)

May as well replace the DATE function:

=WORKDAY(EOMONTH(A1,0),-1)
 
See what I get for not paying attention!

Re: Finding second-to-last workday of month
=WORKDAY(EOMONTH(A1,0),-1)
Click to expand...

That will return the *last* weekday Mon to Fri.

For the 2nd to last weekday Mon to Fri:

=WORKDAY(EOMONTH(A1,0)+1,-2)

Format as Date
 
Back
Top