Why don't astronomers use everyday units to measure distances (what is an AU or a pc)? (Intermediate)
How this formula works: The WEEKNUM function takes two arguments, a date, and, optionally, an argument called return_type, which controls the scheme used to calculate the week number. See the WEEKNUM page for more information. B4 contains a date value for January 5, 2016. The DAY function returns the number 2 representing the calculated week number. Note that by default, the WEEKNUM function uses a scheme where week 1 begins on January 1, and week 2 begins on the next Sunday (when the return_type argument is omitted, or supplied as 1).
The following array formula counts the number of days of the week in one month. With any date of the month in question in cell B38 and the day of week (1 = Sunday, 2 = Monday, ..., 7 = Saturday) in C38. For example, you can calculate the number of Mondays in January-2011 (equals 5).he following formula will return the date of the next Nth day of week (Sunday = 1, Monday = 2, ..., 7 = Saturday) from the start date. The start date is specified in cell B53, the N in C53, and day of week in D53. For example, you can find the date of the 6th Monday following 14-January-2011 (equals 21-February-2011).