Function GetDate

GETDATE() Description

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

Main Characteristics of the GETDATE Function

Syntax:

=GETDATE(Text; Entry)

Parameters:

• Text: Text from which dates need to be extracted.
• Entry: The ordinal number (occurrence) of the required date. It can also have a negative value, which will mean searching for the occurrence from the end of the string. When the value is 0, it returns all occurrences.

Usage Example

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

=GETDATE(Text; Entry)

We will get the following result:

In this example, the following values are used:

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

Download extension

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

After that, this function will be available in all files that will be opened in Excel (LibreOffice Calc).