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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]last YE[/TD]
[TD]3 months[/TD]
[TD]1 year[/TD]
[TD]3 year[/TD]
[TD]5 year[/TD]
[TD]10 years[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12/31/2018[/TD]
[TD]3/31/2019[/TD]
[TD]06/30/2018[/TD]
[TD]06/30/2016[/TD]
[TD]06/30/2014[/TD]
[TD]06/30/2010[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]06/30/2019[/TD]
[TD]06/30/2019[/TD]
[TD]06/30/2019[/TD]
[TD]06/30/2019[/TD]
[TD]06/30/2019[/TD]
[TD]06/30/2019[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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