Hello all,
Using Excel 2007
The current formula tests an employee date of hire (P10) for eligibility of benefits and is working perfrectly if I no not have any rehired employees:
=IF(AND(Q10="",S10="",$B$3-P10>=$AO$1),$AO$2,"")
I would like to add to the formula stating if Q10 (rehire date) is NOT blank, S10="",$B$3-Q10>=$AO$1)$AO$2,"")
Just can't seem to get this figured out.
Thanks for the help.
Using Excel 2007
The current formula tests an employee date of hire (P10) for eligibility of benefits and is working perfrectly if I no not have any rehired employees:
=IF(AND(Q10="",S10="",$B$3-P10>=$AO$1),$AO$2,"")
I would like to add to the formula stating if Q10 (rehire date) is NOT blank, S10="",$B$3-Q10>=$AO$1)$AO$2,"")
Just can't seem to get this figured out.
Thanks for the help.