TOP

GetDate function for Excel

GETDATE() Description

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


Main Features Functions GETDATE

Syntax:

=GETDATE(Text; Entry)

Parameters:

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:

GETDATE formula usage

This example uses the following values:

Download the extension

You can use the GETDATE() function by installing a free extension YouLibreCalc.xlam .

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