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).
=WEEKDAY(A2, 3). Day of the week, with numbers 0 (Monday) through 6 (Sunday) (3). 3. Applies To: Excel 2016, Excel 2010, Excel Starter, Excel 2013, Excel Online, Excel 2016 for Mac, Excel for Mac 2011, Excel 2007.WEEKDAY(A2, 3). Day of the week, with numbers 0 (Monday) through 6 (Sunday) (3). 3. Applies To: Excel 2016, Excel 2010, Excel Starter, Excel 2013, Excel Online, Excel 2016 for Mac, Excel for Mac 2011, Excel 2007.