I am creating a spreadsheet that records:
Date Correspondence Received
Date Correspondence Answered
I want to add a new column that totals the days taken to do this.
Fairly simple on the face of it! However, I don't want to include
weekends in this total. Ideally, I'd like to be able to exclude public
holidays too - perhaps by having a list where I enter such dates and
they are then excluded from the calculation, but this may be a step too
far for my meagre skills...
Any ideas?
Regards,
Baldy
--
BaldySlaphead
------------------------------------------------------------------------
BaldySlaphead's Profile:
http://www.excelforum.com/member.php...fo&userid=1260
View this thread:
http://www.excelforum.com/showthread...hreadid=518190