I have an excel sheet with an auto date calculator function linked to each cells. I want this function to work based on different condition. For eg: (lets say there are two conditions A and B)for condition A (I will put A in A1 cell), I want the date function to be [DATE(YEAR(B2), MONTH(B2), DAY(B2)+5)] and for condition B (I will put B in A2 cell), I want the date function to be [DATE(YEAR(B2), MONTH(B2), DAY(B2)+10)]. Is this possible to do in excel on one sheet based on whichever condition I enter? Thanks a lot.

Nupur