Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Network days
Please could someone tell me how to add 17 network days to a network day and
have the DATE displayed in a cell and not the amount of network days. Lets say. I recieve an order on a specific day and i have to have that order dispatched within 17 network days, is there a formula that can tell me a deadline date? Thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Network days
Thanks but that formula will only return the date 17 workdays from today and
not a date entered in a specific cell (each day that date would change). "מיכאל (מיקי) אבידן" wrote: Try: =WORKDAY(TODAY(),17) Cell should be formatted as DATE. Micky "Sean" wrote: Please could someone tell me how to add 17 network days to a network day and have the DATE displayed in a cell and not the amount of network days. Lets say. I recieve an order on a specific day and i have to have that order dispatched within 17 network days, is there a formula that can tell me a deadline date? Thanks in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Network days
Micky got you 99% of the way there.
Just point Micky's formula to a specific cell, such as... =WORKDAY(B4,17) -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Sean" wrote: Thanks but that formula will only return the date 17 workdays from today and not a date entered in a specific cell (each day that date would change). "מיכאל (מיקי) אבידן" wrote: Try: =WORKDAY(TODAY(),17) Cell should be formatted as DATE. Micky "Sean" wrote: Please could someone tell me how to add 17 network days to a network day and have the DATE displayed in a cell and not the amount of network days. Lets say. I recieve an order on a specific day and i have to have that order dispatched within 17 network days, is there a formula that can tell me a deadline date? Thanks in advance |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Network days
Spot on guys and thanks for your help.
"מיכאל (מיקי) אבידן" wrote: I am really not sure I understood your last post. BUT if I did - isn't it obvious that instaed of TODAY() you can enter a cell address ? Assume the changeable date was typed in A1 and the Workdays days to be added in A2 - in cell A3 try: =WORKDAY(A1,A2) Micky "Sean" wrote: Thanks but that formula will only return the date 17 workdays from today and not a date entered in a specific cell (each day that date would change). "מיכאל (מיקי) אבידן" wrote: Try: =WORKDAY(TODAY(),17) Cell should be formatted as DATE. Micky "Sean" wrote: Please could someone tell me how to add 17 network days to a network day and have the DATE displayed in a cell and not the amount of network days. Lets say. I recieve an order on a specific day and i have to have that order dispatched within 17 network days, is there a formula that can tell me a deadline date? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding network days | Excel Discussion (Misc queries) | |||
Network days - Returns error sometimes. | Excel Discussion (Misc queries) | |||
IF statement and Network days | Excel Discussion (Misc queries) | |||
Network Days | Excel Discussion (Misc queries) | |||
Network days question | Excel Worksheet Functions |