Creating an IF formulae to show if something is current or late

Hi all,

If possible, I would like for column D to display the following information. Sorry the attachment wasn't working for me


A B C D
1 Time Rcvd Time Released 1day/ 2day
2 8/20/2015 14:29 8/21/2015 16:43 1 day
3 8/21/2015 8:00 8/23/2015 8:00 2 day
4 8/20/2015 14:29 8/22/2015 16:43 1 day
5 8/21/2015 8:00 8/24/2015 8:00 2 day


I would like for column D to display the phrase “Current” or Late” depending on if the file went past it’s due date.

For example, Row 2 and 3 should both show that the item is “Current” because they have not exceeding their due date for when the item was released. Row 2 has a specified due date of 1day which was met. Row 3 had a specified due date of 2days which was met.

Row 4 and 5 however should display the phrase “Late” because they both went past their specified due date. Row 4 had a 1day turn time but it took 2 days. Row 5 had a 2 day turn time and it took 3 days.

I am only working with either a 1day or 2day turn time to determine if it is late or not if that helps.

Thanks! I have used daffodil11's formula and it looks like it's what I'm looking for. Would you be able to have this only include business days so that weekends aren't being included in this?

And I would only need it to reflect it if it if it goes into another whole day so the hours wouldn't really matter

For example,
8/20/15 14:29 + 1 day = 8/21/15 16:29 would be fine even though it is two hours later. However, if it was 8/22/15 then it would be late.

Sorry the release date on the weekend was an accident and yes you are correct for line 5. It should actually be on time.

Hi daffodil11,

The colums now say #Value!

This computer isn't allowing me to attach it. The screen just freezes for some reason when I try. I will do it on another computer later on today

Book2.xlsx

Ok I think I finally got it.