autofill date 15th and 30th/28th/29th every month

English
, ,
#1

how to autofill date 15th and 30th/28th/29th every month

#2

… 31st ?

#3

Put 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.

#4

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).

#5

can be done with formula/function. been wondering if this can be done with drag-fill. thanks.

#6

thanks. pls try it, it doesn’t work

Note that Mike updated the formula for A2 and it now works exactly as it should.

#7

thanks mike :slight_smile:

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.