GetDate function for Excel

GETDATE() Description

The GETDATE() function is designed to retrieve dates from text.

Main Features of the GETDATE Function

Syntax:

=GETDATE(Text; Entry)

Parameters:

• Text: The text from which you want to get dates.
• Entry: The sequence number (entry) of the required date. It can also have a negative value, which means searching for an entry from the end of the string. If the value is 0, it returns all entries.

Example Usage

The GETDATE() function is easy to use. You just need to enter any text and specify the serial number of the required date, and Excel will automatically return the specified entry:

=GETDATE(Text; Entry)

We will have the following result:

This example uses the following values:

• Text: A3 - Text from which you need to get dates ("Invoice #100235/001 (25.01.2023)") .
• Entry: B3 - Display all entries (0) .

Download the extension

You can use the function GETDATE() by installing the extension YLC Utilities .

Or its free version YouLibreCalc .

After that, this function will be available in all files that are opened in Excel .