Assuming start date = A2, end date = A3, holidays in B2:B50
=A3-A2-COUNTIF(B2:B50,"="&A2)+COUNTIF(B2:B50,""&A3)

Adjust cell references as needed.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Drewpotlad" wrote:

Hi All,

I know how to subtract holidays from NETWORKDAYS in a formula by defining
them (as in Christmas Day 25/12/2008), but I have a process that is giving me
a headache. It is measured in calendar days, so at present I am doing a
simple subtraction of start date cell - end date cell of process. However, I
obviously cannot account for any holidays in year. Is there a formula/way of
doing this?

Thanks,

Drew