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).
In a date field you can enter two, four, six, or eight digits: 1  If you enter only two digits, this is interpreted as the day, and it will add the month and the year of the work date. 2  If you enter four digits, this is interpreted as the day and the month, and it will add the year of the work date. If the date you want to enter is in the range 01/01/1930 through 12/31/2029, you can enter the year with two digits; otherwise, enter the year with four digits. You can also enter a date as a weekday followed by a week number and, optionally, a year (for example, Mon25 or mon25 means Monday in week 25).