Helo again How can know the last business day of a month? Thanks
N Niek Otten Aug 14, 2006 #2 =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 | |
=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 | |
