Multiple formulas within a cell

[nicolei]

I need a cell to perform multiple functions and can't figure out how to do it. I've attached a copy of the document to hopefully show what I'm trying to do.

I need the column f to automatically determine the number of months by subtracting column e from column b. Once that is done, I need it to...

If eval date is 6 months past the hire date and has not been inst for 24 months, turn red
If eval date is 12 months past the hire date and has been inst for 2 years, turn red

Is this possible?

[MarvinP]

Hi nicolei

My questions is: Why do you need all this information in a single cell? Why not do the logic in helper columns and then give the result at then end? Also, why does it need to be a color change instead of a final result of some Text in a cell. The text would be something like "Pass" or "Fail".

[Cutter]

I'm not sure I follow but are you looking for this as the CF formula:

=OR(AND(F2>=6,D2>=24),AND(F2>=6,D2<=24))

Also, the formula in D2 can be simplified as: =DATEDIF(B2,TODAY(),"m")
and similarly the formula in F2 can be: =DATEDIF(E2,TODAY(),"m")
which eliminates need for column C.