how to autofill date 15th and 30th/28th/29th every month
… 31st ?
2019-10-15 into A1;
=MIN(EOMONTH(A1;0);A1+15) into A2;
=EOMONTH(A2;0)+15 into A3; select A2:A3 and drag-fill down as required.
thanks. pls try it, it doesn’t work. 1/15, 1/31, 2/15, 2/28,3/15,3/31 … it needs to be 15th and 30th for each month (or the 28th or 29th for february).
can be done with formula/function. been wondering if this can be done with drag-fill. thanks.
thanks. pls try it, it doesn’t work
Note that Mike updated the formula for A2 and it now works exactly as it should.