Tips, tutorials, and add-ons
The WEEKDAY function returns a number representing the day of the week for a specific date. By default, it counts Sunday as <code>1</code> and Saturday as <code>7</code>, but you can change this using the optional <code>type</code> argument. The date must be in a valid format, so you have to use the DATE function, wrap it … Read more
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
Learn how to move dates forward for backward by whole years.
Learn how to use the ISDATE function to see if a value is a valid date.
Learn how to find the weeks and days between two dates.