Formula to determine status based on dates in 2 other cells

Lisa Nicoletta

New Member
Joined
Sep 2, 2015
Messages
6
Hello - I'm new to Mr. Excel - please forgive me if I do not yet have the forum etiquette down.

Let me explain what I do currently have correct....
I have 2 columns (Column N has a "projected meeting date", Column O has an "actual meeting date"). I also have one cell (N12 with the "TODAY" formula. I was able to populate Column P "meeting status" based on only Column N (the projected date) and N12 as follows:
If the Proj Mtg Date is less than Today's Date, then the Mtg Status is "Late"
If the Proj Mtg Date is equal to Today's Date, then the Mtg Status is "Due Today"
If the Proj Mtg Date is greater than Today's Date, then the Mtg Status is "Scheduled"​
The formula I (crashed coursed in) to get this is: =IF(N20<$N$12,"LATE",IF(N20=$N$12,"DUE TODAY",IF(N20>$N$12,"SCHEDULED")))

PROBLEM: I also need to determine if the meeting status is COMPLETE. Once a sales rep has their meeting, the actual meeting date is populated in Column O. I've tried to insert another "IF" within the formula to represent that "if a date is in Column O, then Mtg Status is Complete"
No matter how I try this, I continuously get an error. Please help!! :)
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Welcome to the forum.

Try

=IF(O20<>"","Complete",IF(N20<$N$12,"LATE",IF(N20=$N$12,"DUE TODAY",IF(N20>$N$12,"SCHEDULED"))))
 
Upvote 0
Try

=IF(ISBLANK(O12),IF(N20<$N$12,"LATE",IF(N20=$N$12,"DUE TODAY",IF(N20>$N$12,"SCHEDULED"))),"COMPLETE")

Good luck,

CN.

OH. MY. GOD. !!!!!
I have been at this for the past 6 hours. Which led me to this site, which led me to becoming a member...etc
I could kiss you CodeNinja!
This worked!!! *she exhales a huge sigh of relief*
Thank you so SO much!
 
Upvote 0

Forum statistics

Threads
1,223,099
Messages
6,170,107
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top