February 5, 2023
When you use a spreadsheet for things where the timing is essential, you likely include dates and times. Google Sheets offers a collection of functions for formatting, converting, and calculating dates and times to help with your data entry. You might include dates for customer orders or budgeting and times for hours worked or time…

When you use a spreadsheet for things where the timing is essential, you likely include dates and times. Google Sheets offers a collection of functions for formatting, converting, and calculating dates and times to help with your data entry.

You might include dates for customer orders or budgeting and times for hours worked or time spent on a project. Because dates and times can come in all forms, you may need to manipulate these elements to display correctly in your sheet.

Find the Day, Month, or Year From a Date

You may have a list of birthdates, order dates, or similar where you want to extract only the day, month, or year. For this, you can use the same named functions: DAY, MONTH, and YEAR.

RELATED: How to Change the Default Date Format in Google Sheets

The syntax for each is the same as DAY(date), MONTH(date), and YEAR(date) where the argument can be a cell reference, date, or number.

Here, we have a date in cell D1 and use the following formulas to return the day, month, and year:

=DAY(D1) =MONTH(D1) =YEAR(D1)


Read Full Article Source

24 thoughts on “13 Google Sheets Date and Time Functions You Need to Know

Leave a Reply

Your email address will not be published. Required fields are marked *