Calendar dialog

Use this dialog to specify a date value or values. For example, to analyze sales on a particular day you might use this dialog to specify the day for a worksheet parameter.

Alternatively, you can close this dialog and type a date directly into the date field, or manually edit an existing date in the date field.

<Year area>

Use this area to select a year.

<Month area>

Use this area to select a month.

<Date area>

Use this area to select a date (or a set of dates).

Notes

  • If the list of allowable dates is restricted, some areas of the calendar might be grayed out.

  • If multiple dates are allowed, you can also use the multi-select keys available (platform dependent) to select multiple dates or ranges of dates. For example:

    • To select multiple dates, press the Ctrl key and click another date.

    • To select a range of adjacent dates, click on the first date in a range, press the [Shift] key, then click on the last date in the range. All dates between the two are selected.

    • To select multiple ranges of dates. do the following:

    1. Click on the first date in a range, press the [Shift] key, then click on the last date in the range.

      All dates between are selected.

    2. Release the [Shift] key and press the [Ctrl] key.

    3. Click on the first date in the next range, press the [Shift] key, then click on the last date in the range.

      All dates between are selected in addition to the existing ranges selected.