The computers at work don't let us install anything so the add-in isn't
possible for me. I don't understand how to put what you've given me into the
MIN statement?
Is this right? It appears to be giving me the right dates but I'm unsure
about sending it to my supervisor until I'm sure it works with all the
senerios.

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


"John C" wrote:

Two ways. Assuming the base date is in cell D3

1: =DATE(YEAR(D3),MONTH(D3)-18,DAY(D3))

2: =EDATE(D3,-18)

Note: The EDATE function is available if you have the Analysis ToolPak
add-in installed.
--
John C


"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