Thread: Network days
View Single Post
  #2  
Old April 20th, 2010, 09:05 PM posted to microsoft.public.excel.misc
Sean
external usenet poster
 
Posts: 491
Default 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