LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Andy100
 
Posts: n/a
Default Problems with date calculations (bank hols etc)

I have a database of dates of claims received.

Column A has the customers name, Column B is the date claim was received.

Problem is that in column C i want to enter the 60th day (i.e. Whatever is
in column B + 60days - however this MUST NOT include Saturdays or Sundays in
the calculation and should also NOT include bank holidays). I have a
separate sheet of all the bank holidays listed. I haven't a clue how to
solve this one !. Please help. So for e.g Mr Smith puts his claim in on 16th
March 2005, i want column C to add 60 WORKING days onto this, but miss out
the bank holidays (i.e. 25/4, 28/4, 2/5 and 30/5), the answer i get should
be 13/6/05. Bearing in mind that the date of receipt of the claim actually
counts as 1 day also.

Please help !

Andy


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting up "Year to Date" Calculations in a Pivot Table Project64 Excel Worksheet Functions 1 March 22nd 05 01:50 AM
Time and date calculations Bob Excel Worksheet Functions 1 February 22nd 05 04:05 PM
time and date problems still Michaela Excel Worksheet Functions 0 February 7th 05 05:31 PM
Date sort problems Graham_Wright Excel Discussion (Misc queries) 2 January 4th 05 05:00 PM
Count data entries and date problem Gef Excel Worksheet Functions 5 November 4th 04 02:30 PM


All times are GMT +1. The time now is 10:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"