Formula for date comparison

I need to compare dates in two cells to show progress on a project. For example, if the in progress date of the project is within 3 months of projection, it's on time. If it's 4-5 months, it's in progress, and 6+ months is delayed. So I need three if comparisons within the formula that will spit out "on time", "in progress", or "delayed" depending on the date comparisons (today's date compared to projected complete date). I've set up nested ifs with numerical values before but not dates. Any advice?

Thanks!

With the "In Progress Date" in A2 and the "Projected Date" in B2, try something like this:

=LOOKUP(DATEDIF(A2,B2,"m"),{0,4,6},{"On Time","In Progress","Delayed"})

Let me upload a sample of what I'm working on. What I'm trying to do is take the date in column D and compare it to the date in column C, and if there is a 0-3 month difference, it's on time. If it's 4-5 months,
in progress, and 6+, delayed. There is a formula in column D that calculates the 6 month projection. Is this possible?

Did you try to adjust the ranges in the formula from post #2 to match your layout (A2 to C2 and B2 to D2)?

That is:

=LOOKUP(DATEDIF(C2,D2,"m"),{0,4,6},{"On Time","In Progress","Delayed"})

I did, it said too many arguments?

When I copy the formula from post #4 and paste it into F2 of the sample sheet that you shared in post #3, it works fine for me.

I don't know what I did the first time, but it works for me once I copied it. Thanks!!

You're welcome, thanks for the rep!