Return Text based on a date
I am trying to write a formula that will return the text "Current" or Expired in the INS status Column based on whether the dates in the GL, AUTO and WC dates are past today's date. Hitting a wall. Attached snip of the sheet
Thank you in advance for any help!
Comments
-
THANK YOU!!! That's perfect and works like a charm!
-
Just ran in to one instance where it did not work. 2 of the dates (GL and AUTO) are in June, but the WC was in February and it's returning a Current instead of the Expired. I'm playing with it but if you know of the top of your head! Thanks!
-
Hmm, I double checked mine and it seems to be working.
-If all three are in the Future = "Current"
-If one or more of them are Less than Today = "Expired"
Is that the logic you are looking for? If not, if you give a bit more detail I can revise the formula.
-
It seems like replacing the AND with OR should do the trick as it sounds like you are looking to flag as "Expired" if any of the dates are in the past.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!