I have luckily been able to put together most of the help I need from other threads and postings, but I am still a little short of my answer. Should be an easy one for an eperienced person though.
Problem: I have =Today() in A2 and I have an expiration date in C4. Now my formula cell is G2 and it has =IF((C4-A2)<30,1,IF((C4-A2)<14,2,0)).
The issue with this formula is that when there are less than 30 days before expiration it shows a 1 even if it is under 14 days away. I need it to show that 2 if it's under 14 but can't get it. Only a 1 or 0. Thanks for anyone who can help!
Bookmarks