Smart Date Calendar With Cell-Specific Date Validation 

The primary objectives are: fast and accurate entry of dates, without sacrificing speed of entry or risking invalid or incorrectly typed dates.

Designed to ensure high-quality data entry:

• Easily ensures dates are always valid workdays

• Stops entry of invalid dates (numbers, transposition, format)

• Visual calendar helps identify days weekdays vs weekends

• Easily restricts entry to working days, avoiding holidays

• Clear error messages that identify any problems

Designed for fast entry of dates:

• Click the Today button to select today

• Click a day to select the date within the current month

• Use the scroll buttons at the top to move the month up or down

• Click on the Month or Year for a drop downs that you then click

• If you don’t need to change the date, use Tab or Arrows to move on

Designed for fast navigation to next cell:

• Enter Key -  go down to next visible row

• Tab key - go right to the next visible column

• Arrow keys – go left, right, up or down to the next visible cell

• OK button – using your default Excel cursor movement it selects
  he next cell (to go right or to go down)

Visual guides aiding correct date selection:

• There are clear titles above the columns

• Weekdays and weekend days have different colors 

• Week number is displayed alongside each date row

• Month Name is displayed in full in the heading

• Year is boldly displayed in the heading

• Selected date is boldly displayed in red (in local format)

​​

Other keys:

• Delete key - deletes cell content and exits

• Escape key – exits leaving date unchanged