Oct 09, 2014 · Google Forms: Adding a List of Calendar Dates - Duration: 3:39. Alice Keeler 21,133 views Step 1: Enter the date. Step 2: Click the first cell and move the mouse to the right bottom of the cell. Cursor changes to plus and drag the plus symbol to the extend you need to autofill the date series.

Week numbers in Google Sheets How to get the week number from a date. To get the ISO week number (1-53) from a date in cell A1, use =ISOWEEKNUM(A1).. 21 is a code that identifies ISO week numbers among other week numbering scheme.