Last business day of month?

  • Thread starter Thread starter Casrlos A.
  • Start date Start date
=WORKDAY(EOMONTH(A1,0)-7,5)

You can include a list of holidays; look in HELP for WORKDAY

If you get a #NAME error:

Tools>Add-ins, check Analysis Toolpak

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Helo again
| How can know the last business day of a month?
|
| Thanks
|
|
 
You must log in or register to reply here.

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

help with formula to calculate what column to use 1
finding last transaction in month 12
A server error occurred 0
Excel Monthly Spread sheet. 12
Calculate the weekday of last FULL week of month 6
Excel Message box with days of month & date. 1
code snippets 1
Calculating 10 Business Days from the Last Business Day of the Mon 5

Back
Top