Sep 23 2023 08:41 PM
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
Sep 23 2023 09:31 PM
Sep 24 2023 02:51 AM
@mtarler thank you - I’ll try this in the morning.
appreciate the time you took to reply.