Changes in version 8.6 - May 15, 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.

Finished

On May 15, 2024 the new version 8.6 has been released. Download

Supported Excel versions

ASAP Utilities 8.6 works with:

• Excel 365 Desktop
• Excel 2024 (preview)
• Excel 2021
• Excel 2019
• Excel 2016
• Excel 2013
• Excel 2010

On any Windows system that meets the Excel system requirements.

New/improved

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

The date picker popup simplifies selecting and inserting dates into your worksheet.

It displays a visual calendar, allowing you to quickly identify and select dates instead of having to type the date manually.

It is handy for quickly finding and entering dates accurately, without errors in format or value.

• Browse by year and month to pick a date.
• Select a date and it automatically inserts it into the active cell.
• If a cell isn't formatted as a date, the Date Picker will insert the picked date and apply the short-date format according to your regional Windows setting.
• The Date Picker popup "floats", so you can easily keep it visible and select the cells to insert a date.
• You can enable the Date Picker to show automatically when double-clicking a date cell. It then appears when you double-click a cell with a date or date format.
• You can choose to have the calendar view start with today’s date (default), or the date of the selected cell.
• You can choose the starting day of the week: Monday, Sunday, or Saturday.
• The calendar shows (ISO) week numbers for easy identification.
• Choose to close the form after date entry or move to the next cell.
• Simply close the Date Picker by pressing the ESC-key or clicking the X in the title bar.

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.