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 Days360 Function in Excel. When you want to work out how many days there are between two dates, the function to use is Days360( ). We want to work out how many days there are between the 15th of April 2016 and the 3rd of May 2016. So click inside cell C2 and do the following: Click on the Formulas tab at the top of Excel.