Wouldn't that also subtract 18 months from H1?

We started from:
=MIN(G1-18mths,H1,I1-18mths)

"Mike H" wrote:

Maybe

=DATE(YEAR(MIN(G1:I1)),MONTH(MIN(G1:I1))-18,DAY(MIN(G1:I1)))

Mike

"Elizabeth" wrote:

I tried this formula but it comes up with 04/02/07 but shouldn't it be
02/28/07?

G H I J
08/31/08 2/28/08 09/01/08 =MIN(G1-DATE(0,18,0),H1,I1-DATE(0,18,0))

In line two I get 07/16/07 but I think it should be 06/14/07?

12/14/08 12/14/08 12/15/08 =MIN(G2-DATE(0,18,0),H2,I2-DATE(0,18,0))

"Mike H" wrote:

Try

=MIN(G1-DATE(0,18,0),H1,I1-DATE(0,18,0))

Mike

"Elizabeth" wrote:

I want to do this formula only 18 months instead of 547.5 days so it gives me
exact dates instead of ballpark? Does anyone know how?

=MIN(G1-547.5,H1,I1-547.5)

Thank you. Elizabeth