How it works

These functions allow manipulate dates within a selection of cells to convert them between text dates and dates.

How to use it:

Step 1

Highlight/Select the cells to be manipulated.

Step 2

In the ‘More’ drop down of the Formatting and Grooming group, click on the date manipulation function to be performed.

Step 3

On completion, the text will be converted as specified.

Scroll to Top