Solved How do I write a formula to show expiration date.

September 20, 2018 at 08:04:18
Specs: Windows 7
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.

See More: How do I write a formula to show expiration date.

Report •

#1
September 20, 2018 at 08:48:44
✔ Best Answer
With your Date in cell A1 and the X in cell B1:

     A          B         C
1) 1/1/2018	X     1/31/2018

In Cell C1 enter the formula:

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

See how that works for you.

MIKE

http://www.skeptic.com/


Report •
Start a discussion
Related Solutions
See More ↓


Ask Question