WEEKNUM function - Microsoft Support
This article describes the formula syntax and usage of the WEEKNUM function in Microsoft Excel. Returns the week number of a specific date. For example, the week containing January 1 is the first week of the year, and is numbered week 1. There are two systems used for this function:
Turn on or off week numbers in month view and the Date Navigator
Week numbers can appear in the calendar month view and on the Date Navigator in the folder pane. Week numbers restart at the beginning of each year. By default, week numbers are turned off.
DatePart Function - Microsoft Support
Start with week in which January 1 occurs (default). Start with the first week that has at least four days in the new year. Start with first full week of the year. Remarks. You can use the DatePart function to evaluate a date and return a specific interval of time.
WEEKNUM function
Returns the week number of a specific date. For example, the week containing January 1 is the first week of the year, and is numbered week 1. There are two systems used for this function: System 1 The week containing January 1 is the first week of the year, and is numbered week 1.
DatePart Function
Remarks. You can use the DatePart function to evaluate a date and return a specific interval of time. For example, you might use DatePart to calculate the day of the week or the current hour.. The firstdayofweek argument affects calculations that use the "w" and "ww" interval symbols.. If date is a date literal, the specified year becomes a permanent part of that date.
WEEKDAY function - Microsoft Support
This article describes the formula syntax and usage of the WEEKDAY function in Microsoft Excel. Returns the day of the week corresponding to a date. The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday), by default. WEEKDAY (serial_number, [return_type]) The WEEKDAY function syntax has the following arguments:
Welcome to your Outlook calendar - Microsoft Support
Learn how to switch your Outlook calendar view between day, week, or month views, change the week displayed, and see different shared calendars. There are different views to choose from: Month - View the entire month. Week - View the week from Sunday through Saturday. Work Week - View the work week from Monday through Friday.
Date and time functions (reference) - Microsoft Support
Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.
ISOWEEKNUM function - Microsoft Support
2012年3月9日 · This article describes the formula syntax and usage of the ISOWEEKNUM function in Microsoft Excel. Returns number of the ISO week number of the year for a given date. The ISOWEEKNUM function syntax has the following arguments. Date Required. Date is the date-time code used by Excel for date and time calculation.
Weekday Function - Microsoft Support
Returns a Variant (Integer) containing a whole number representing the day of the week. Syntax. Weekday(date [, firstdayofweek] ) The Weekday function syntax has these arguments:
DateDiff Function - Microsoft Support
Returns a Variant (Long) specifying the number of time intervals between two specified dates. Syntax. DateDiff ( interval, date1, date2 [, firstdayofweek] [, firstweekofyear] ) The DateDiff function syntax has these arguments: Required. String expression that is the interval of time you use to calculate the difference between date1 and date2.