Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Want to Improve Formula
I managed to create the following formula:
=IF(AND(J3<"",L3<""),IF(L3="air",IF(WEEKDAY(J3+[15import.xlsx]Sheet2!$ A$2,2)<6,J3+[15import.xlsx]Sheet2!$A$2,WORKDAY(J3+[15import.xlsx]Sheet2! $A$2,1)),IF(L3="dhl",IF(WEEKDAY(J3+[15import.xlsx]Sheet2!$B$2,2)<6,J3+[1 5import.xlsx]Sheet2!$B$2,WORKDAY(J3+[15import.xlsx]Sheet2!$B$2,1)),IF(L3 ="ups",IF(WEEKDAY(J3+[15import.xlsx]Sheet2!$C$2,2)<6,J3+[15import.xlsx]S heet2!$C$2,WORKDAY(J3+[15import.xlsx]Sheet2!$C$2,1)),IF(L3="ocean",IF(WE EKDAY(J3+[15import.xlsx]Sheet2!$D$2,2)<6,J3+[15import.xlsx]Sheet2!$D$2,W ORKDAY(J3+[15import.xlsx]Sheet2!$D$2,1)))))),"") Which basically calculates delivery dates for products that I purchase. If a delivery date falls on a weekend, the formula automatically adjusts the delivery date to the next available Monday. The formula does its basic job but I would like to improve things. While the formula can detect if a delivery date falls on a weekend, it cannot detect if it falls on any other type of company holiday which falls on a weekday. (For instance, Christmas this year falls on a Friday.) Common sense tells me that I need to create some sort of Excel table that includes all the company holidays that fall on a weekday, but how would I integrate that to the existing formula? Thanks. -- tb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to improve efficiency of array formula | Excel Worksheet Functions | |||
improve formula, Possible Genious needed !!! | Excel Worksheet Functions | |||
improve formula offset and indirect | Excel Worksheet Functions | |||
How can improve this formula? | Excel Worksheet Functions | |||
Need to improve a formula | Excel Worksheet Functions |