I need help with an IF function. I have a column of dates that I want evaluated. If the date is less than 6 months ago from today, I want to return a value. If the date is between 7-12 months from today, return another value. If between 1-2 years from today, another value. And lastly, if greater than 2 years, return another value. Can someone please help me?
Bookmarks