|
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
Is there a formula to identify the last business day of a month?
I know that =EOMONTH(“12/2/06”,0) will return 12/31/06, but I need something that will return 12/29/06. Could there be a takeoff on NETWORKDAYS?
Actually, I need to know the same answer for the reverse. I also will need to identify the first business day of the month.
Here are functions that take holidays into account. They assume that
a) you have created a range of holidays and named it Holidays, and
you have installed the Analysis ToolPak add-in.
Last business day of the month containing the date in cell A1:
=WORKDAY(EOMONTH(A1,0)+1,-1,Holidays)
First business day of the month containing the date in cell A1:
=WORKDAY(EOMONTH(A1,-1),1,Holidays)
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Notifications
