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

Copper Contributor

Current Todays date in J1

Column I             Column J                 Column K

Due Date

Current| Completed

Overdue

 

Date

Completed

1-Aug-23  
1-Aug-23 31-Aug-23
31-Oct-23  

 

I have 3 formulas that work but I can't string them together to work. 

 

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" 

 

Please help a little old lady LOL that has a headache from trying to figure this out. 

 

Thanks

 

Cathy

 

 

 

2 Replies
try:
=IFS(ISNUMBER(K2:K4),"Completed", TODAY()>I2:I4, "Current", TRUE, "Overdue")

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