I'm trying to set up a formula that produces 4 possible responses in a cell. If I3 is blank, then I4 needs to be blank. If the date in I3 is within 90 days of today's date, DUE should appear, if the date in I3 is more than 90 days in the future, CURRENT should appear, and if the date in I3 is past, then EXPIRED should dunedin_ss.xlsxappear.
I have a formula that covers the first 3 conditions, but when I try to add a further condition for expired, I get an error message and I'm not sure where I am going wrong! Help, please..!
Thanks for any help that anyone can give.
Bookmarks