Delivery date

[spotsteven]

I have a customer that needs in excel a delivery date. They enter a zip code, I have excel to tell me how many days to delivery.. However Weekends and hoildays do not count as days... My zip is in Cell C15 and the number of bussiness days is in C16. I need to put the delivery date in D15. I have tried varouis look up and if commands but just can't get it to work. I know very little about VBA/Macro.

To show as example.. Today 3/25 , delivery will take 4 days.. So it need to show 3/31.

Thanks in advance...

 

[Makrini]

How about use the formula in the analysis addin

WORKDAY

Returns a number that represents a date that is the indicated number of working days before or after a date (the starting date). Working days exclude weekends and any dates identified as holidays. Use WORKDAY to exclude weekends or holidays when you calculate invoice due dates, expected delivery times, or the number of days of work performed.

If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in.

How?

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click OK.
If necessary, follow the instructions in the setup program.
Syntax

WORKDAY(start_date,days,holidays)