Want to create a TAT Calculation file

[nitesh_greatie]

Hi All,

I want to calculate a Turn around time file... likewise
In my work I have to calcuate and give a time frame to my customer
Like wise today is my working day and the tat for the same is five working day from thje day we received work...

Please note we do not include government holiday and weekends
I want a to create a file where I enter todays date and it automatically give me the. Day and day till the fifth day or the last day of the TAT
On each colume
Eg
Today..... day 1.... day 2.... day3.... day 4... day5
... please help frens...

Thank You som much

Nitesh
09811057185

[FDibbins]

assuming your data is in A1, try this in B1...
=WORKDAY(A1,5)