Excel: Creating Date, Year, Month, and Day Series in Worksheet

 Last reviewed: November 30, 1994
Article ID: Q24157

SUMMARY

To create a series of dates, months, years, or days of the week in Microsoft Excel, follow the appropriate procedure below.

To create a series of dates, follow these steps:

  1. Type the first date in the series into a cell (for example, A1).

  2. Select that cell (in this case, A1).

  3. From the Data menu, choose Series.

  4. If you want a column of dates, select Series In Columns. If you want a row of dates, select Series In Rows.

  5. Under Type, verify Date is selected.

  6. Under Date Unit, choose the unit you want (Day, Weekday, Month, Year).

  7. Enter the final date in Stop Value.

  8. Click the OK button.

To create a series of months, follow the steps for creating a series of dates with the following modifications:

  1. In the first cell, place the first day of the month desired (for example, 3/1/90 for March).

  2. Choose Month in step 6 above.

  3. Select the cells with dates.

  4. From the Format menu, choose Number.

  5. Type in "mmmm" (without quotation marks) in the Format box. Click the OK button.

To create a series of years, follow the steps for creating a series of dates with the following modifications:

  1. In the first cell, place the first day of the year desired (for example, 1/1/1990).

  2. Choose Year in step 6 above.

  3. Select the cells with the dates.

  4. From the Format menu, choose Number.

  5. Type "yyyy" (without quotation marks) in the Format box. Click the OK button.

To create a series of days, follow the steps for creating a series of dates with the following modifications:

  1. In the first cell, type a date that gives the desired first day of the week (for example, for Monday, you could use the date 11/18/91).

  2. Choose either Weekday or Day in step 6 above.

  3. Select the cells with the dates.

  4. From the Format menu, choose Number.

  5. Type "dddd" (without quotation marks) in the Format box. Click the OK button.

MORE INFORMATION

For more information about series, see pages 253-256 in the "Microsoft Excel User's Guide" version 3.0 manual. If you are using Excel 2.2, see pages 133-134 in the "Microsoft Excel Reference" version 2.2 manual.

Note: This information is also valid for Microsoft Excel for Windows versions 2.1, 2.1c, and 3.0, and Microsoft Excel for OS/2 versions 2.2, 2.21, and 3.0.

KBCategory: kbother
KBSubcategory:

Additional reference words: 1.0 1.00 1.03 1.04 1.06 1.50 1.5 2.10
2.10c 2.20 3.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.