LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Calculate Date range
 
Posts: n/a
Default Calculate Date range

Hi All,
Would like your help to provide me the instructions or steps on how to
calculate the TAT(Turn around Time) for my requests excluding weekend and
public holidays

For Example 1,
I received a request on 1st Sept'05 and I completed the request on 6th Sept'05
During this period, the actual TAT is only 4 working days, exclude 3rd Sept
and 4th Sept'05 which were weekend in this week.

Kindly let me know how to solve the calculation as well as excluding the
public holiday if during this period.
 
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
How do I create a schedule from a list of dates ? Gavin Morris Charts and Charting in Excel 2 October 28th 10 04:08 PM
How do I calculate if a date is in a certain time frame? Pe66les Excel Worksheet Functions 19 August 27th 05 11:07 PM
count date occurances in range of dates... Alex Excel Worksheet Functions 2 July 27th 05 04:15 PM
Update cell based on date range deversole Excel Discussion (Misc queries) 3 July 6th 05 01:58 PM
adding occurrences for date range Mike Excel Discussion (Misc queries) 0 April 8th 05 11:33 PM


All times are GMT +1. The time now is 01:29 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"