formula help: Retirement eligible calculation

[dallascowboys]

rules:
60years + 10 years of experience OR
65 years and older.

I have DOB in Column P and Hire date in Column Q, and I would like to have column R populate "yes" or "no'

Can you please help.

Thanks,

 

[Eric W]

Welcome to the MrExcel board!

Try:

=IF(OR(AND(DATEDIF(P4,TODAY(),"y")>=60,DATEDIF(Q4,TODAY(),"y")>=10),DATEDIF(P4,TODAY(),"y")>=65),"yes","no")

 

[Dave Patton]

You can use a reference cell with Today's date or put Today in the formula.
You could use True or False instead of adding the If.

Excel 2010
	O	P	Q	R
1	Key Date Today	DOB	Hire	Qualify
2	10-Oct-18	15-10-56	1-Nov-05	TRUE
3	10-Oct-18	15-10-50	15-11-10	TRUE
4		15-10-50	15-11-10	Yes
3a

Cell Formulas
Range	Formula
R2	=OR(AND(DATEDIF(P2,O2,"y")>=60,DATEDIF(Q2,O2,"y")>=10),DATEDIF(P2,O2,"y")>=65)
R3	=OR(AND(DATEDIF(P3,O3,"y")>=60,DATEDIF(Q3,O3,"y")>=10),DATEDIF(P3,O3,"y")>=65)
R4	=IF(OR(AND(DATEDIF(P4,TODAY(),"y")>=60,DATEDIF(Q4,TODAY(),"y")>=10),DATEDIF(P4,TODAY(),"y")>=65),"Yes","No")

 

[dallascowboys]

Welcome to the MrExcel board!

Try:

=IF(OR(AND(DATEDIF(P4,TODAY(),"y")>=60,DATEDIF(Q4,TODAY(),"y")>=10),DATEDIF(P4,TODAY(),"y")>=65),"yes","no")

Thank you Eric, this works. I missed the "AND" formula, appreciate it.

 

[Eric W]

Glad we could help.