Strange Conditional Formula

**holly3251** · 01-28-2009, 11:21 AM

I'm trying to make a formula to calculate the difference in a date between two dates. For exaple, in my business we have a due day for something. So the due date could be Feb 10, we need to know if it was done on time, late, or early. So I've gotten it to display late by doing this: =IF(B2>A2, "Late", (A2-B2)) But then I can't figure out how to incorporate this: =IF(B2=A2, "On Time") or =IF(B2<A2, "Early").

I would like to displaly this all in one cell. So if the due date is Feb 10 and it's turned in Feb 8 it's early, turned in Feb 10 it says on time, turned in Feb 11 it's late.

I also tried this but it didn't work: =OR(IF(B2>A2,"Late")*IF(B2=A2,"On Time")*IF(B2<A2,"Early"))

I would appreciate any help!

**DonkeyOte** · 01-28-2009, 11:35 AM

One way

Please Login or Register  to view this content.

**royUK** · 01-28-2009, 11:43 AM

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.

Moved to Functions Forum

**holly3251** · 01-28-2009, 11:55 AM

Thanks DonkeyOte. That works!!!

**Janiel** · 04-27-2016, 09:18 PM

How can i get the formula for date with text Early, Delay and On time

For example:

Date of Submission is April 27, 2016 but they submit it before the deadline meaning early to submit, then if after the deadline meaning its delay and if with same date meaning its on time.
hope you can help me on this.

Thank you,

Janiel

**FDibbins** · 04-28-2016, 12:12 AM

Janiel welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.