Link to home
Start Free TrialLog in
Avatar of Lawrence Salvucci
Lawrence SalvucciFlag for United States of America

asked on

Workdays By Quarter for current year

How can I compute the # of workdays for each quarter for the current year? I also need to exclude holidays which I have set up in my spreadsheet.
Avatar of NBVC
NBVC
Flag of Canada image

Use the Networkdays function:

e.g.

=Networkdays(Date(2014,1,1),Date(2014,3,31),holidays)

that's for 1st quarter.

where holidays is your named holiday range (you can also replace with range like $A$1:$A$10).
Avatar of Lawrence Salvucci

ASKER

Thanks. Let's say I have a cell that just has the 4 digit year in it and when I change that it will recompute the workdays by quarter. How can that be done so I don't have to hard code the dates in the formula?
ASKER CERTIFIED SOLUTION
Avatar of NBVC
NBVC
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you very much!