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 WEEKNUM function accepts a date and returns the week number (1 through 54) of that date. To calculate the week number, the date must be in a valid format, so you have to use the DATE function, wrap it in quotes, or use a cell reference to a date. If your days, months, and … Read more