Pre-release version 8.6 - May 2, 2024

Designed to simplify your work

We are working with great enthusiasm, for over 25 years already, to ensure that ASAP Utilities continues to evolve and stay one of the world's most useful and popular add-ins for Excel users.

Download pre-release version 8.6

The new version is scheduled to be released officially within the next few weeks.
Download our fully functional and thoroughly tested pre-release and help shape the final version:
ASAP_Utilities_8-6_RC5_Setup.exe 27.1 MB (May 2, 2024)

Supported Excel versions

ASAP Utilities 8.6 works with:

• Excel 365 (both 32- and 64-bit version)
• Excel 2021 (both 32- and 64-bit version)
• Excel 2019 (both 32- and 64-bit version)
• Excel 2016 (both 32- and 64-bit version)
• Excel 2013 (both 32- and 64-bit version)
• Excel 2010 (both 32- and 64-bit version)

On any Windows system that matches the Excel system requirements.

New/improved

NEW: Numbers & Dates  ›  17. Date Picker...

This date picker popup simplifies selecting and inserting dates into your spreadsheet.
It is handy for quickly finding and entering dates accurately, without errors in format or value.

• It pops up a calendar where you can quickly browse by day, month, and year to choose a specific date.
• This calendar also displays (ISO) week numbers, making it easy to identify weeks.
• You can choose if the first day of the week starts on Monday, Sunday or Saturday.
• It lets you easily select a specific date by clicking on it, instead of having to type the date manually.
  Once you select a date, it automatically inserts it into the selected cell.
• The Date Picker popup "floats", so you can easily keep it visible and select the cells where you want to insert a date.
• You can choose to automatically close the form after date entry, or move to the next cell (according to your personal "After pressing Enter, move selection Direction" in Excel's Advanced settings).
• If a cell isn't formatted as a date yet, it will apply the short-date format according to your regional Windows setting.
• To close the Date Picker popup, you can simply press the ESC-key or click the X in the title bar.
• Via the settings button, or via 'ASAP Utilities Options  ›  1. Settings, language and contact information...' you can enable 'Show Date Picker Popup when double clicking on a date cell'.
  The Date Picker popup Calendar will then show when you double click on a cell that either contains a date, or has the number format set to a date.

Screenshot 1, week starts on Sunday:

Screenshot 2, week starts on Monday:

Screenshot 3, Settings:

New: =ASAPCELLCOLOR(cell)

Returns the color number of the cell.
This is a number representing the RGB color value.

NEW: =ASAPFONTCOLOR(cell)

Returns the color number of the font of a cell.
This is a number representing the RGB color value.

General

Fixed some known small issues and made a few small improvements.

Free upgrade if you purchased your license in 2016 or later

If you purchased your license in 2016 or later (version 7.x) then you get version 8.6 free of charge. You can use the same license details.
If you purchased a license longer ago, then please contact us for a 50% discount to upgrade to versions 8.

To upgrade to a newer version of ASAP Utilities that is covered by your license, just install the new version "on top" of the existing version on your computer.
ASAP Utilities will then automatically recognize your settings and license information if you have already entered that previously.