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).
To find out the serial number of a date, select the cell containing the date then open the Format Cells dialog by (in Excel 2007 and later) expanding the Number section of the Home tab (click the arrow in the lower right corner) or (in Excel 2003 and earlier) opening the Format menu and choosing Cells.o find out the serial number of a date, select the cell containing the date then open the Format Cells dialog by (in Excel 2007 and later) expanding the Number section of the Home tab (click the arrow in the lower right corner) or (in Excel 2003 and earlier) opening the Format menu and choosing Cells.