Autofill date based on date in another cell

Hi,
I am looking for a function that would automatically fill in a date in one cell based off the date listed in a different cell.

For example:
A4 cell contains 3/31/05 and A15 contains 3/31/04

I would like to be able to fill in A4, and have A15 automatically fill. It needs to be the last day of the month for the prior year. So in February, A4 would be 2/28/05 and A15 should fill as 2/29/04.

Thank you for any help!!!

Place this formula in A15:

=EOMONTH(A4,-12)

Cheers!

Bruce

You may need the Analysis ToolPak installed to have this function. Go to Tools>Addins and check the box for this item.

Good Luck

Bruce

I'm glad it worked for you. Thanks for the feedback, it is always appreciated.

Cheers!