EDATE minus 6 minus 6 is not same as -12

0

Is there some way to get 2014-06-30 minus 6 months to be 2013-12-31 rather than 2013-12-30 (i.e always end of month)

enter image description here

Viktor Mellgren

Posted 2015-05-05T12:10:52.047

Reputation: 662

Answers

1

Use =EOMONTH(F1,-F2) instead of EDATE. EOMONTH goes to the end of the month for a given month. -6 goes backward.

Byron Wall

Posted 2015-05-05T12:10:52.047

Reputation: 497

Asked: 2015-05-05T12:10:52.047

Viewed: 41 times

Active: 2015-05-05T12:55:48.833