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