Hi,
I would like to create 3 separate date ranges for upcoming deadlines to be displayed as 1, 2, and 3 based on how close the deadline is to the current date. Range 3 is over a year away, range 2 is between 6 months and a year away, and range 1 is less than 6 months away. I have a cell dedicated to today's date (not sure if that is necessary) and I've come up with the following formula from reading different pieces of help forums:
=IF(AND(G2>=J2+365,"3") , IF(AND(G2>=J2+183,G2<J2+365,"2") , IF(AND(G2<J2+183,"1"))))
J2 is the "Today's Date" cell, and I'm hoping to carry this formula down the entire G column. If anyone can help that would be awesome. Excel is telling me the formula is broken.
Bookmarks