1

I would like for a date to increment after 9 entries like the below:

1/1/2018
1/1/2018
1/1/2018
1/1/2018
1/1/2018
1/1/2018
1/1/2018
1/1/2018
1/1/2018
1/2/2018
1/2/2018
1/2/2018
1/2/2018
1/2/2018
1/2/2018
1/2/2018
1/2/2018
1/2/2018
1/3/2018
1/3/2018
1/3/2018
1/3/2018
1/3/2018
1/3/2018
1/3/2018
1/3/2018
1/3/2018

etc. until the end of the year. Is there anyway to automatically have this happen. I have tried highlighting and dragging but it never increments, just repeats from the beginning.

2

The easy way is to put 9 1/1/2018 in A1:A9 then in A10 put

=A1+1 

then copy down.

enter image description here


Now if you want one formula in that you can drag down from A2.

Put the starting date in A1 and this formula in A2:

=$A$1+INT((ROW(1:1))/9)

Then copy down.

enter image description here

  • @B.steiner if this worked for you then please mark as correct by clicking the check mark by the answer. – Scott Craner Dec 28 '17 at 16:43

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.