Subtracting dates

srosk

Board Regular
Joined
Sep 17, 2018
Messages
132
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 YE3 months1 year3 year5 year10 years
12/31/20183/31/201906/30/201806/30/201606/30/201406/30/2010
06/30/201906/30/201906/30/201906/30/201906/30/201906/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?

Code:
=EDATE(F3,-3)


Thank you kindly, as always :)
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Watch MrExcel Video

Forum statistics

Threads
1,108,954
Messages
5,525,879
Members
409,669
Latest member
JDCupps

This Week's Hot Topics

Top