Director of Operations

I need to return a value from a specific cell, based on whether a date in another cell is 1 year, 2 years, 3 years, 4 years, or 5 years older than today’s date [using TODAY()]

Example of what I’m trying to do in 1 nested formula:

if A1 (Date) is less than 1 year older than today, return set $ value from cell B1, If A1 is greater than 1 year from today but less than 2 years from today, return set $ value from cell C1, If A1 is greater than 2 years from today but less than 3 years from today, return set $ value from cell D1, If A1 is greater than 3 years from today but less than 4 years from today, return set $ value from cell E1

etc.

 

 

By: Sheri Lopez

Leave a Reply

Your email address will not be published. Required fields are marked *