Date Picker: Inserting formatted dates into cells

In the Spreadsheet Editor, you can quickly insert dates into selected cells using the Date Picker plugin. This plugin provides an integrated calendar widget and allows you to choose from various date formats and apply them to multiple cells simultaneously.

ImportantStarting with ONLYOFFICE Docs 8.2, no plugins come with the editors by default. The plugins shall be installed via the Plugin Manager.

1. Switch to the Plugins tab and choose Date Picker.
2. Select the cells where you want to insert the date.
3. Click the Select date field and choose the date from the calendar.
4. Click the Select date format field and choose the preferred date format.
5. Click the Insert date button.

After inserting the date, the Date Picker interface resets to today's date, and you can then insert another date the same way.

Available date formats

The plugin supports various date formats, including:

• mm/dd/yyyy
• dd-Mon-yy
• Day of week, Month dd, yyyy
• And other common formats