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
Learn how to find the weeks and days between two dates.
Learn how to find the number of weeks elapsed between two dates.
Learn how the WORKDAY.INTL function calculates a future or past date based on a specified number of working days.
The ISOWEEKNUM function accepts a date and returns the ISO week number (1 through 54) of that date. The date must be in a valid format, so you must use the DATE function, wrap it in quotes, or use a cell reference to a cell containing a date. An ISO week starts on Monday. The … Read more