Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
count date occurances in range of dates... | Excel Worksheet Functions | |||
Update cell based on date range | Excel Discussion (Misc queries) | |||
adding occurrences for date range | Excel Discussion (Misc queries) |