Remove holidays from calculation
Someone didn't read the OP's complete message and that person is... me!
Sorry, I didn't see your whole message (mainly because I didn't scroll down
to the bottom of it).
--
Rick (MVP - Excel)
"Rick Rothstein" wrote in message
...
Someone didn't read the help files for the NETWORKDAYS function...
"Syntax: NETWORKDAYS(start_date,end_date,holidays)
.....
.....
Holidays is an optional range of one or more dates to
exclude from the working calendar, such as state and
federal holidays and floating holidays. The list can be
either a range of cells that contains the dates or an
array constant of the serial numbers that represent the
dates."
--
Rick (MVP - Excel)
"Sal" wrote in message
...
=IF(COUNT(K13:L13)<2,"",NETWORKDAYS(K13,L13)-1)
This formula already excludes weekends from the calculation.
Do you know how I could improve this formula so that it does not include
holidays in the calculation, I can specify the holidays, and I will not
get
an error message if Column K is blank?
Or
Do you know how I can improve this formula so that if Column K is blank I
will not get a #VALUE! message where the calculation should be?
=NETWORKDAYS(K13,L14,Holidays!A1:A29)-1
|