Hi
I need to calculate the working days between two dates excluding any holidays from 2011 to 2013. I am using the formula NETWORKDAYS(start_date,end_date,datevalue(“xxxx”). I am trying to include all the dates on the attached lis into the datevalue part for the formula.
Thanks
Regards
Cortlyn
Last edited by Cortlyn; 03-24-2013 at 09:47 AM.
You can include a whole range, e.g.
=NETWORKDAYS(E2,F2,$A$3:$C$11)
where E2 holds your start date and F2 the end date
Audere est facere
Thank you very much Daddylonglegs. I was trying to put the range in as "datevalue($a$3:$c$11)"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks