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

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

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

if function constains date
 

Thank you very much