TOP

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:

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:

Example of using the GETDATE() function
Example of using the GETDATE() function

In this example, the following values are used:

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).


This function is also available in the following extensions: YLC LightYLC FunctionsYLC Utilities

The YLC Utilities menu in LO Calc

The YLC Utilities menu in LO Calc

The YLC Utilities menu in Excel

The YLC Utilities menu in Excel