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)
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)
1
Use =EOMONTH(F1,-F2)
instead of EDATE
. EOMONTH
goes to the end of the month for a given month. -6
goes backward.