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)

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

Top