What it does
Date Picker opens a calendar in a pane next to your sheet. Pick a day and it writes a real Excel date into the selected cell, so sorting, filters and formulas keep working.
- Month and week views with ISO week numbers. The calendar jumps to the date in the cell you select.
- Date, or date and time, in your regional format, yyyy-mm-dd, dd/mm/yyyy, mm/dd/yyyy, a long date, or the cell's own format.
- ISO week beside the cell, if you want it.
- Jalali (Persian) and Hijri calendars. Pick a date in either calendar; Excel still stores a normal date.
- Worksheet functions:
=CAL.ISOWEEK(A2)and=CAL.ISOYEAR(A2), and with ProCAL.JALALI,CAL.HIJRI,CAL.FROMJALALIandCAL.FROMHIJRI. - English, Persian and Arabic interface, right to left where needed. It respects workbooks that use the 1904 date system.
Free and Pro
| Feature | Free | Pro |
|---|---|---|
| Gregorian calendar, ISO weeks, date and time formats | Yes | Yes |
| CAL.ISOWEEK and CAL.ISOYEAR | Yes | Yes |
| Jalali and Hijri calendars | No | Yes |
| Jalali and Hijri functions | No | Yes |
| Fill a selection with one date, or a series by day, workday, week or month | No | Yes, up to 10,000 cells |
| Jalali or Hijri text beside the cell, custom number format | No | Yes |
Your data
The add-in reads only the cells you select and writes only the dates you insert. Your workbook is never sent to BLZN Works. It contacts blznworks.com only to check a Pro key and to send usage counts that carry just the product, the channel and the event. The privacy policy has the details.
Availability
Date Picker is an Office add-in for Excel, but it is not on Microsoft AppSource yet. We will add the install link here when it is. For questions, use the contact form.
Excel is a trademark of Microsoft Corporation. BLZN Works is not affiliated with Microsoft.
Price
Date Picker for Excel Pro will cost:
- $15 per year
- $29 once, with no renewal
Pro goes on sale once Date Picker for Excel is published in its store, so you can install it before you pay. Contact us and we will let you know when it opens.