V
vennesa
I am using the workday formula: =WORKDAY(start_date, days, holidays)
But it's not calculating the holiday list for some reason - and it's
NOT throwing me an error. It's just not calculating the list.
My holiday list is referenced as H7:H17
So the formula I have plugged in is: =WORKDAY(E8,5,H7:H17)
It doesn't calculate the weekends (which is good) - but it completely
neglects the holiday range.
Any ideas?
All help is greatly appreciated!
Thanks,
Vennesa
But it's not calculating the holiday list for some reason - and it's
NOT throwing me an error. It's just not calculating the list.
My holiday list is referenced as H7:H17
So the formula I have plugged in is: =WORKDAY(E8,5,H7:H17)
It doesn't calculate the weekends (which is good) - but it completely
neglects the holiday range.
Any ideas?
All help is greatly appreciated!
Thanks,
Vennesa