Ask Your Question
0

Auto increment weekday and date

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

calendar2019 gravatar image

Hi,

I have a spreadsheet where each cell has the following format

Weekday (linebreak)
Date

For example:

Tuesday
1/1/2019

Next cell:

Wednesday
1/2/2019

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
0

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:

=TEXT(DATE(2019;1;1)+ROW()-1;"NNN"&CHAR(10)&"M/D/YYYY")

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

Stats

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

Seen: 100 times

Last updated: Nov 13 '18