Need a function to calculate the estimated arrival date

[DorothyFan1]

I have a sheet where I need to create a function to calculate the final arrival date to a shipped item.

A1 is the Current Date
A2 is the Shipping Date
A3 is the number of days estimated for delivery
A4 is the calculated date of arrival of shipped item.

I need to be able to change the cell in A3 to the number of days expected for shipped item is to be delivered. A4 calculates the arrival date for the item in question. The shipping date is always greater than the current date.

Any ideas on what function can do this? Thanks in advance.

[zbor]

This? =B2+B3

[DorothyFan1]

This? =B2+B3

The function needs to account for the current date. It needs to know if the shipping date is later than the current date before making the calculation. Otherwise simply adding B2 and B3 gives only a static answer irrespective of the current date. In other words if I change the date in B1 and it's later than the shipping date the function needs to return a text string saying the current date is later than the shipping date and the calculation can't continue the formula.

Wait a minute. I just figured out the solution to my own question. Here's my formula

if(B1>=B2,"can't calculate",B2+B3).

But now I need a way to have the function tell me on what day the arrival date falls on...Mon, Tues, Weds, Thurs, Fri. Any way I can do that? Thanks.

[zbor]

Great...
Now make =B4 (same date twice) and format it as ddd or dddd