Formula to calculate 2 months prior to a date

Hello -

Not sure if this is possible but I am trying to see if there is a formula that would automatically calculate the logic below:

A1 = the review date (for this example let's say 3/17/16)
B1 = the start of the lookback period (i.e. =TODAY()-1, 3/16/16)
In C1 = I want to calculate 2 months prior to the lookback period, so 2 months from 3/16/16 is 1/16/16. Because the fluctuation in days in a month, just subtracting 60 from the lookback date will not work.

Any ideas?

thanks!

Hmm, never knew about that EDATE Function before!

Or =DATE(YEAR(B1),MONTH(B1)-2,DAY(B1))

thank you guys, for now these do seem to work even if I use an April date which would result in a February (shorter month) result

Yes Tony you are correct, your formula is the one I am using.

Originally Posted by Tony Valko

If the lookup back date was 8/31/2016 what date would be 2 months prior?

Very good point! Just one of a few reasons the calendar we use is a bit silly.