Ask Your Question
0

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

asked 2019-10-15 07:19:46 +0100

raraland gravatar image

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

edit retag flag offensive close merge delete

Comments

... 31st ?

Mike Kaganski gravatar imageMike Kaganski ( 2019-10-15 07:28:30 +0100 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2019-10-15 07:51:16 +0100

updated 2019-10-15 08:14:03 +0100

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.

edit flag offensive delete link more

Comments

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

raraland gravatar imageraraland ( 2019-10-15 08:02:06 +0100 )edit

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

raraland gravatar imageraraland ( 2019-10-15 08:05:04 +0100 )edit

thanks. pls try it, it doesn't work

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

erAck gravatar imageerAck ( 2019-10-15 12:49:55 +0100 )edit

thanks mike :)

raraland gravatar imageraraland ( 2019-10-15 18:08:09 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-10-15 07:19:46 +0100

Seen: 39 times

Last updated: Oct 15 '19