I have a date and a category. I need to determine an expiration date based on the date the information was entered and the category that it falls into. For example, the data was entered on 1/1/18 and is in the category of X which expires in 30 days. How do I write the formula to show the expiration date.

With your Date in cell A1 and the X in cell B1: A B C 1) 1/1/2018 X 1/31/2018In Cell C1 enter the formula:

=IF(AND(A1<>"",B1="X"),A1+30,"")

See how that works for you.

MIKE

Ask Your Question

Weekly Poll