Help with Formula not sure if it should be IF IFS OR AND

Question

Current Todays date in J1Column I&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Column J&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Column KDue DateCurrent| CompletedOverdue&nbsp;DateCompleted1-Aug-23&nbsp;&nbsp;1-Aug-23&nbsp;31-Aug-2331-Oct-23&nbsp;&nbsp;&nbsp;I have 3 formulas that work but I can't string them together to work.&nbsp;&nbsp;1st rule - if a date is in Column K then return "Completed"2nd Rule - if Column I (due date) date is less than today's date (J1) then returns "Current" - if date is greater than today's date (J1) then return "Overdue"&nbsp;&nbsp;Please help a little old lady LOL that has a headache from trying to figure this out.&nbsp;&nbsp;Thanks&nbsp;Cathy&nbsp;&nbsp;&nbsp;

mtarler · Answer

try:=IFS(ISNUMBER(K2:K4),"Completed", TODAY()&gt;I2:I4, "Current", TRUE, "Overdue")

cathycathy43 · Answer

mtarler&nbsp;thank you - I’ll try this in the morning.&nbsp;appreciate the time you took to reply.&nbsp;

Forum Discussion

Help with Formula not sure if it should be IF IFS OR AND

2 Replies

Due Date	Current\| Completed Overdue	Date Completed
1-Aug-23
1-Aug-23		31-Aug-23
31-Oct-23