I tripping over proper syntax for this:
Where Cell A1 = DATE
I want Cell B1 to output based on the following:
If A1 < 01/01/1974, then X
If A1 >= 01/01/1974 and <= 12/31/1976, then Y
If A1 > 12/31/1976, then Z
Eaxmple:
A1 = 05/18/1975, B1 = Y
I know there are some if's, ands, commas, and parenthesis involved, but I can't seem to get a structure that excel likes.
Thank you!
Bookmarks