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.