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!