Helo again
How can know the last business day of a month?
Thanks
Helo again
How can know the last business day of a month?
Thanks
=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
"Casrlos A." <carlin334@msn.com> wrote in message news:%23OfTzW6vGHA.4872@TK2MSFTNGP02.phx.gbl...
| Helo again
| How can know the last business day of a month?
|
| Thanks
|
|
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks