Combining multiple IF statements to result in a date

[Carrie2525]

Hello!

I have almost finished my spreadsheet project that I was working on, yesterday. I've hit one final snag, though. I need to auto-populate a couple of dates that result from calculations and multiple IF statements, and I would VERY much like to combine all of these conditions into one big equation. Here is an example of one calculation that I'd like to write for cell B12:

If the number of days between B8 and B3 < 90, then B12 = (B8 + 90)
If the number of days between B8 and B3 > 89, but <180, then B12 = (B8 + 179)
If the number of days between B8 and B3 > 179, then B12 = “Indefinite”
If B7 = “N”, then B12 = “N/A”

**I have been using the DATEDIF formula option for the first part of these equations with good success. Example: =(DATEDIF(B8,B3,”D”))>179
**in the cases where B7 = “N”, B8 will be left blank)
**for the first three conditions, there would be a date in B8, and a “Y” in B7

I am so grateful for any help you could offer. Would love to have this project off of my plate, once and for all. Thanks

Excel 2012
	A	B
1	Division	Human Resources
2	Name	John Adams
3	Start Date	1-Jun-15
4	Experience Level (E/I)	E
5	Expiration Date of SR04	15-May-15
6	Regression Date	1-Apr-15
7	L/R Qual (Y/N)	N
8	Expiration Date of LD00	2-Feb-15
9
10
11
12	Program is Valid Through:	(This needs to be a date)
Sheet1

 

[gaz_chops]

Hi Carrie,
Your 1st 2 if's don't seem correct! If<90 then if>89? Should it be <90 then >=90?

Gaz

Edit: Actually reading it again i think it is right, doh!

 

[gaz_chops]

Try

=if(b7="N","N/A",if(b3-b8<90,B8+90,if(b3-b8>179,"Indefinite",b8+179)))

 

[Carrie2525]

Gaz, what would I do without you? It's perfect. Thank you so very much. I can adapt the rest of my formulas to match this one. Every time you help me, I learn more about Excel. I thank you for that.

 

[gaz_chops]

You're very welcome.