Calendar Importer – Bring Your Calendar to Sheets
Use the Calendar Importer Google Sheets add-on to bring events from Google Calendar into your spreadsheet.
day
Types of Date and Time Functions in Google Sheets
The date and time functions in Google Sheets can be grouped into different categories based on their purpose.
DAYS360 Function – Google Sheets
The DAYS360 function calculates days using 30 days for each month. When using a 365-day daily interest rate computation, the interest rate is divided by 365 and multiplied by the principal for each day you calculate interest. When using a 360-day year method, the interest rate is divided by 360 and multiplied by the principal … Read more
DATEVALUE Function – Google Sheets
The DATEVALUE function accepts a date value in any valid format and returns it as a serial number. Spreadsheets store dates and times as serial numbers in Google Sheets, so they work in formulas (you can add March plus June). You can use the DATEVALUE function to prepare dates to be sorted, filtered, or used in formulas. … Read more
Show the Day of the Week as Text – Google Sheets
This tutorial shows you two ways to display your dates as the day of the week in your spreadsheet. The default is to show the month, day, and year together. Therefore, you will have to make a few changes depending on the type of output you want. Grab a copy of this template to follow … Read more