Função do Google Sheets

DATE

Returns the serial number of a particular date.

Gerar uma fórmula com IA A mesma função no Excel

Esta função funciona no Google Sheets da mesma forma que no Excel — mesma sintaxe e argumentos.

Sintaxe

DATE(year, month, day)

The DATE function creates a valid date value from individual year, month, and day components. It is particularly useful when date components are stored in separate cells or generated by other formulas.

Argumentos

yearobrigatórioThe year component, typically a 1-4 digit number.
monthobrigatórioThe month of the year, represented by a number from 1 to 12.
dayobrigatórioThe day of the month, represented by a number from 1 to 31.

Exemplos

=DATE(2023, 12, 25)

Resultado: 2023-12-25

Returns the date for December 25, 2023.

Perguntas frequentes

What happens if the month is greater than 12?

The function adds that number of months to the first month of the specified year.

Funções relacionadas

TODAY NOW YEAR MONTH DAY