logo ASAP Utilities
HomeExtra features for ExcelTip of the Day | Tuesday May 5th, 2026

Tip of the Day | Tuesday May 5th, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Insert Date Using a Calendar Popup...

This tool opens a calendar popup (date picker) that lets you quickly insert a date into the selected cell without typing.
The calendar displays the full date context at a glance: day, month, year, weekday name, and ISO week number. This makes it easy to look up, verify, and insert dates accurately.
Key Features:
  • Click a date on the calendar to insert it into the selected cell.
  • Browse by month and year to find the correct date.
  • Automatically applies your system's short date format if the cell isn't already formatted as a date.
  • Option to start the calendar on today's date or the date in the selected cell.
  • Enable it to appear when double-clicking a date or date-formatted cell.
  • Choose your preferred starting day of the week (Monday, Sunday, or Saturday).
  • View ISO week numbers on the calendar.
  • Option to move to the next cell or close the popup after inserting a date.
  • Keep the calendar floating while you move through your worksheet.
  • Close the popup with the ESC key or the X button.
    Benefits:
  • Prevents manual entry errors and inconsistent date formats.
  • Makes it easier to look up and insert dates, such as next Friday or the first Monday of next month.
  • Helps users who are unfamiliar with date formatting in Excel.
  • Saves time when working with date-driven tasks like schedules, forms, or reports.
    Tip:
    By default, you can use the shortcut Control+Alt+T to quickly open the Calendar Popup.

    Screenshots

    Example screenshot: 1
    Example screenshot: 1, Numbers & Dates  ›  Insert Date Using a Calendar Popup...
    Example screenshot: 2
    Example screenshot: 2, Numbers & Dates  ›  Insert Date Using a Calendar Popup...
    Example screenshot: 3
    Example screenshot: 3, Numbers & Dates  ›  Insert Date Using a Calendar Popup...

    Starting this tool


    Numbers & Dates  ›  Insert Date Using a Calendar Popup...

    Choose your language preference below

    English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

    Trustpilot
    Download  


    • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
    For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.