Pichup date match with hours- expected date.

[visha_1984]

Hi,

If picup date is 01-04-2013 and delivery tat is 24 hours then expected delivery date should be 02-04-2013. if 02 april 2013 is sunday then expected date should be 03-04-2013.
I have attached sample workbook.
Hope some one understand what i want.

[Lemice]

Hello,

I assume you want to find the expected date, which should be pick up date plus the time in TAT, and plus one day if it falls into Sunday right?
If so, you can try this formula

Please Login or Register  to view this content.

And here is the sample file.

[visha_1984]

Hi,lem

thanks for quick reply
but check same date--
PICKUP DATE TAT Expected Date of Delivery OUT PUT
20-Apr-13 24 hrs 22-Apr-13 22-Apr-13
20-Apr-13 48 hrs 22-Apr-13 23-Apr-13

[bebo021999]

Try this:

Please Login or Register  to view this content.

[visha_1984]

Hi,Lem

if pick up date is saturday and tat is 24 hours then expected date should monday.
if pick update is friday and tat is 48 hours then expected date should monday.
if pick update is Thursday and tat is 72 hours then expected date should monday.

[visha_1984]

Try this:

Please Login or Register  to view this content.

Hi Bebo
thanks but same happen here.

[bebo021999]

Hi,Lem

if pick up date is saturday and tat is 24 hours then expected date should monday.
if pick update is friday and tat is 48 hours then expected date should monday.
if pick update is Thursday and tat is 72 hours then expected date should monday.

So if pick up date is Sat and tat is 24 or 48 then expected date should monday, right?
That Lemice's and mine did.

[Lemice]

I see that you wanted to count sunday as a free 24 hours.

I have a question, is the hours in TAT has a maximum? Or it can be any number in the world?

[bebo021999]

daddylonglegs, where are you ?

[visha_1984]

I see that you wanted to count sunday as a free 24 hours.

I have a question, is the hours in TAT has a maximum? Or it can be any number in the world?

No ,Lem the hours TAT has a maximum.

[Lemice]

Try this formula then

Please Login or Register  to view this content.

Another question:
- 24 hours from April 1, 2013 is April 2, 2013.
- 48 hours from April 1, 2013 is April 3, 2013.
- None of the 3 date is Sunday, then why you expected it to be April 4? (it's written in your expected column)

[bebo021999]

Same question as Lemice, with my formula:

Please Login or Register  to view this content.

in which INT(....) count number of sunday occur

[bebo021999]

Also another question:
Monday, 1-Apr-2013 plus 78 hour (3.25 days) should be 4-Apr, while you expected it to be 5 -Apr?

[visha_1984]

Also another question:
Monday, 1-Apr-2013 plus 78 hour (3.25 days) should be 4-Apr, while you expected it to be 5 -Apr?

Lemic and Bebo ,

Its typing mistake from my side

both formula works fine thank u very much