Home |
Search |
Today's Posts |
#1
|
|||
|
|||
if function constains date
Hi everyone
I need help about creating formula that contains date not an amount. I tried everything but did not figure out how For example; Shipping lead time for a product is 60 days. Date order is 3/1/2001 Date delivered is 5/20/2001 How can I write a formula that shows you if the delivery on time or not? Thanks to all |
#2
|
|||
|
|||
if function constains date
assuming the order date i sin cell A1 and the delivery date is in cell B1
=If ((B1-A1)+160,"Late","On-time") -- _______________________ Naz, London "arifnj" wrote: Hi everyone I need help about creating formula that contains date not an amount. I tried everything but did not figure out how For example; Shipping lead time for a product is 60 days. Date order is 3/1/2001 Date delivered is 5/20/2001 How can I write a formula that shows you if the delivery on time or not? Thanks to all |
#3
|
|||
|
|||
if function constains date
=IF(date_delivered-date_ordered60,"Late","On time")
-- HTH RP (remove nothere from the email address if mailing direct) "arifnj" wrote in message ... Hi everyone I need help about creating formula that contains date not an amount. I tried everything but did not figure out how For example; Shipping lead time for a product is 60 days. Date order is 3/1/2001 Date delivered is 5/20/2001 How can I write a formula that shows you if the delivery on time or not? Thanks to all |
#4
|
|||
|
|||
if function constains date
Thank you very much
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with a date function formula | Excel Discussion (Misc queries) | |||
Date function | Excel Worksheet Functions | |||
Excel date function | Excel Worksheet Functions | |||
Is there a function to show future date | Excel Worksheet Functions | |||
Date Function | Excel Worksheet Functions |