Hello,
I have this table with different dates and want to know how to make if/and/or function formula for it. The dates within 30 days should say Expiring. The day of and up to 13 days pass is Expired. 14 past the expiration date is on hold. Those within compliance are Approved.
I have this table with different dates and want to know how to make if/and/or function formula for it. The dates within 30 days should say Expiring. The day of and up to 13 days pass is Expired. 14 past the expiration date is on hold. Those within compliance are Approved.