Ask Your Question

Auto increment weekday and date

asked 2018-11-13 19:47:09 +0200

calendar2019 gravatar image


I have a spreadsheet where each cell has the following format

Weekday (linebreak)

For example:


Next cell:


I want to automatically display the whole year that way, so I am looking for a way to automatically fill/increment all cells in that way. When I do it in the regular way by dragging downward, it doesn't work.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-11-13 19:57:02 +0200

updated 2018-11-13 20:13:25 +0200

  1. Put 2019-01-01 into A1.
  2. Put 2019-01-01 into A2.
  3. Set cell format of A1 to NNN.
  4. Set cell format of A2 to M/D/YYYY.
  5. Select 2 cells: A1:A2.
  6. Using small square in the bottom right corner of selection rectangle, drag the selection down as far as you need, and check the result.

Another way, using two-lined cells:


This formula is intended for row 1. If the first calendar row is not 1, then the -1 part should be corrected accordingly.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-11-13 19:47:09 +0200

Seen: 100 times

Last updated: Nov 13 '18