Finding second-to-last workday of month

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!
 
R

Rick Rothstein

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)
 
T

T. Valko

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

May as well replace the DATE function:

=WORKDAY(EOMONTH(A1,0),-1)
 
T

T. Valko

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula for if result is friday, make it thursday. 1
Workday function question 2
Listing only the workdays of a month 4
Excel inventory Sheet for workday month 1
Find last weekday of the month with vba for all months 3
How to shift a weekend date to the last or next workday 2
Sum Workdays 5
Alternative to WORKDAY when Analysis ToolPak not loaded 9

Top