Typing dates and times in Excel manually is a pain, and it's easy to make mistakes.
Ready to start project
So many dates to type
Dates in Excel are a pain
Sound familiar? You're not alone.
All you need to enter dates and times in Excel fast and accurately
- Instant Date and Time Picker: Automatically display a convenient date and time picker above any cell in your Excel sheet—whenever a date or time is detected — saving you time and reducing errors.
- Effortless Date Selection: Simply choose your desired date from the intuitive calendar, and watch as the selected date instantly updates the corresponding cell(s) in your worksheet.
Save time when working with Excel dates
Eliminate frustration when entering date and time values in Excel. Easily verify and edit dates visually in Excel.
Set Dates From Calendar or Picker
Pick a date from the calendar popup date-time picker and update the selected cells.
Eliminate Date Typos
Prevent date errors and ensure 100% valid date values.
See Cell Date on Calendar and Picker
Select any date-containing cell and see the corresponding date on the 12 month calendar.
Pricing
Choose Your One-Time Purchase Option
Excel Date-Picker and Calendar
XLNavigator Date-Picker and Calendar for Excel Windows Desktop.
$27
USD
- Pop-up Date-Picker
- Time-Picker
- Calendar Date-Picker
- Date visualizer
- Dynamic 12-month calendar
- Try free for 7 days, no credit card required
- One time purchase, lifetime updates
- 3 Windows Devices per purchase
XLNavigator All-In-One (Complete Version) Excel Add-In for Excel Windows Desktop.
$149
USD
- Excel Date-Picker and Calendar
- Excel Vertical Sheet Tabs
- Excel Object Explorer
- Excel SQL Range Import
- ... and more (coming soon)
- Try free for 7 days, no credit card required
- One time purchase, lifetime updates
- 3 Windows Devices per purchase
3000+ happy users
Ready to get started?
Download now and experience the difference. No strings attached.
Try it free for 7 days
Full access. No credit card required.
3000+ happy XLNavigator users!
Don't take our word for it. Here's what they have to say about XLNavigator.
Really easy to use. The tutorials are really useful and explains how everything works. Working with dates and navigation in Excel is a breeze now!
Having a date-picker calendar on the side in Excel is so convenient when working with dates in Excel. Although setting dates in cells from the calendar is handy, visually seeing corresponding dates on the calendar when selecting cells containing date values is very handy.
FFrancois TredouxXLNavigator is genuinely an incredibly useful addition to Excel. I often receive Excel files with 15-20 sheets or more of financial data from my clients, which I have to review and use in preparing the clients' financial statements and tax returns. The Excel vertical tabs immediately show me all the sheets and even hidden sheets in the spreadsheet without having to scroll one bit, and that is a massive time-saver for me! Feels like a super power! :D
AAltea Muller
The XLNavigator calendar and date-picker have spoiled me, and I cannot go back to typing dates manually in Excel. The resizeable calendar makes planning so easy. Planning, reviewing, and flipping dates in Excel is incredible! 100% worth it 🚀🚀🚀
MMyrna Botha
I love the interactive calendar on the side that lets me pick a date visually and update the selected cells with that date. The calendar can show me a full 12-month view and week numbers, and that is very handy as I plan out training and planning schedules for the upcoming year. I also got spoiled with the vertical tabs that feel more natural to use in Excel.
MMartin PretoriusImporting ad hoc data from Excel into SQL is easy with this tool. I love the option to specify a minimum varchar length and step up in specified increments in varchar length instead of just setting the varchar length to the longest string in Excel. Exporting tables and views are also quick and easy the way it should be
JJulie Machado
Having the sheet tabs in Excel on the side feels natural and is effective for finding and selecting specific sheets, and even in smaller spreadsheets, I see the Excel vertical tabs as my preference. I am not sure why this is not part of Excel out of the box. What's not to love?
RRene ReetzThe ability to quickly select any block of cells of data in Excel and then load it as a new table in SQL Server in no time is beneficial to me. I work with SQL and Excel every day. Trying to import data into SQL Server using SSIS or the import wizard several times daily is frustrating, especially when running into import errors!
FFred Lieb
Jon Muller
"The tool is exactly what I didn't even know I needed."
Selecting a range of data cells and inserting that data selection as a new table into SQL Server on an ad-hoc basis is part of my daily workflow as I do most of my data analysis and database conceptual prototyping in SQL and Excel. Using the SQL Server Import and Export Wizard requires several steps to import data from Excel, and errors can occur during the import process. XLNavigator lets me stay focused on my task rather than going down a tangent trying to get the data into SQL Server. What a simple yet powerful tool!
DDaniel HerbertCombining the Excel vertical tabs on the left side with the horizontal standard tabs makes for an excellent solution to plan out spreadsheet-based content rapidly. I use the handy interactive calendar tool daily for planning dates. I do everything in Excel, and I cannot do so without this amazing add-in.
LLouise Schultz
FAQ
Date Picker Questions
- Simply click on a cell that contains or should contain a date, and the Date Picker calendar will pop up. Select your date visually, and it's automatically entered into the cell in the correct format.
- Yes! The Date Picker respects your Excel cell formatting and regional settings. Whether you use MM/DD/YYYY, DD/MM/YYYY, or any other format, the picker adapts automatically.
- Absolutely. The Date Picker includes a time picker for entering hours and minutes. Perfect for scheduling, time tracking, and any Excel work involving timestamps.
- Yes. You can use the Date Picker to enter dates into cells that are referenced by formulas. The picker enters the date value, and your formulas calculate normally.
- The picker stays open after each selection, so you can quickly move to the next cell and pick another date without reopening it. Great for filling in date columns.
Not ready to purchase? Start with our free guide.
Learn 10 Excel shortcuts that'll save you hours every week — completely free.
Save time and increase your productivity
XLNavigator also includes an ever-expanding list of features and functions that make working with data in Excel easier and less error-prone. Hence, you will be less frustrated and more effective using Microsoft Excel.
- Gain situational awareness and security by seeing all sheets, including hidden and very hidden sheets.
- Navigation features like Vertical Sheet Tabs save you time and effort when reviewing and editing the content of workbooks.
- Date functionality like the Calendar Date Picker helps prevent date entry errors and makes you more efficient in reviewing, planning, and working with dates.
- Excel data analysts and power users who use SQL Server and Excel together will benefit from our SQL features and be more efficient and effective in using Excel and SQL together.