DAY() is a Google Sheets function that returns the day of the month for a given date. For example, if you enter the date "1/1/2018" into a cell, the DAY() function will return "1".
DAY() takes a date as an input and returns the day of the week for that date. The syntax is DAY(date).
DAY is an example of how to use the Google Sheets DAY function, which returns the day of the month for a given date. In the following example, the function is used to return the day of the month for the date "1/1/2018":
=DAY(1/1/2018)
The result of the function is "1".
There are a few instances when you should not use DAY in Google Sheets. One example is when you are working with a data set that spans a period of more than 86,400 days (31 years). In this case, using the DAY function will return the wrong result. Another instance when you should not use the DAY function is when you are working with a data set that includes dates before January 1, 1900. In this case, using the DAY function will return a result that is off by more than 68 years.
There are a few similar formulae to DAY in Google Sheets. The DAY function returns the day of the month for a given date. The DATE function returns the date for a given year, month, and day. The TODAY function returns the current date. The YEAR function returns the year for a given date. The MONTH function returns the month for a given date. The WEEKDAY function returns the day of the week for a given date.