How to get month from Google Sheets date?

E

Egor Sabyanin2021-11-29 14:29:53

Google Sheets

Egor Sabyanin, 2021-11-29 14:29:53

There is a field with a date format of the type (day.month.year), I want to get the month number using the MONTH () function.

Cell A1 stores the date 01/01/2022, using the formula MONTH(A1) and getting 12/31/1899. What's wrong?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Alexander, 2021-11-29
@EgoSab

Wrong cell format with formula. You have the Date format, you need Numeric.