# sample delivered based on two seperate dates

1. ## sample delivered based on two seperate dates

Hi Guys,

Another one for you...

Column J represents - expected delivery date

Column K represents - Delivery status

Column L represents - actual delivery date

currently the cells in column K the formula is =IF(J6="","",IF(J6>=O2,"Awaiting Delivery","Delivery Outstanding!"))

Cell ref O2 is the =NOW() function

I would like column K to also say Delivered when a date is inserted into column L.

Any ideas?

2. ## Re: sample delivered based on two seperate dates

Try this

Formula:
`Please Login or Register  to view this content.`

3. ## Re: sample delivered based on two seperate dates

You should put the function =TODAY() in O2, as NOW() returns the date and time.

Try this formula for the extra requirement:

=IF(J6="","",IF(L6>0,"Delivered",IF(J6>=\$O\$2,"Awaiting Delivery","Delivery Outstanding!")))

Hope this helps.

Pete

4. ## Re: sample delivered based on two seperate dates

Hello,

In order to have "Delivered" in column K if a date is entered in column L one option would be:

``Please Login or Register  to view this content.``

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts