Subtracting dates

[srosk]

I have a table with the following headers. I have the values already listed in the 1st and 3rd row. Need to figure out, how to calculate the 2nd row.

last YE	3 months	1 year	3 year	5 year	10 years
12/31/2018	3/31/2019	06/30/2018	06/30/2016	06/30/2014	06/30/2010
06/30/2019	06/30/2019	06/30/2019	06/30/2019	06/30/2019	06/30/2019

<tbody>
</tbody>

I tried to use the following for items like the 3-month, but no avail. I believe that it should work for everything but last YE and 3 months.

How do I use a formula to essentially get 12/31 of the previous year? Best way to get the last day of the month, 3 months ago?

=EDATE(F3,-3)

Thank you kindly, as always

 

[jim may]

Check out the EOMONTH() FUNCTION