Skip to search results
PRODUCT
Office.com results
MINUTE function
Article Returns the minutes of a time value. The minute is given as an integer, ranging from 0 to 59. Syntax MINUTE ( serial_number ) Serial_number   is the time that ...
SharePoint Foundation 2010 , SharePoint Server 2010
WEEKDAY function
Article 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. Syntax WEEKDAY ( seria...
SharePoint Foundation 2010 , SharePoint Server 2010
HOUR function
Article Returns the hour of a time value. The hour is given as an integer, ranging from 0 (12:00 A.M.) to 23 (11:00 P.M.). Syntax HOUR ( serial_number ) Serial_number  ...
SharePoint Foundation 2010 , SharePoint Server 2010
YEAR function
Article Returns the year corresponding to a date. Syntax YEAR ( serial_number ) Serial_number   is the date of the year you want to find. Remarks Dates are stored as se...
SharePoint Foundation 2010 , SharePoint Server 2010
TIME function
Article Returns the decimal number for a particular time. The decimal number returned by TIME is a value ranging from 0 (zero) to 0.99999999, representing the times fro...
SharePoint Foundation 2010 , SharePoint Server 2010
TODAY function
Article Returns the serial number of the current date. The serial number is the date-time code used for date and time calculations. You can use the TODAY function only ...
SharePoint Foundation 2010 , SharePoint Server 2010
SECOND function
Article Returns the seconds of a time value. The second is given as an integer in the range 0 (zero) to 59. Syntax SECOND ( serial_number ) Serial_number   is the time...
SharePoint Foundation 2010 , SharePoint Server 2010
DATEVALUE function
Article Returns the serial number of the date represented by date_text. Use DATEVALUE to convert a date represented by text to a serial number. Syntax DATEVALUE ( date_...
SharePoint Foundation 2010 , SharePoint Server 2010
DATE function
Article Returns the sequential serial number that represents a particular date. Syntax DATE ( year , month , day ) Year   The year argument can be one to four digits. ...
SharePoint Foundation 2010 , SharePoint Server 2010
DATEDIF function
Article Calculates the number of days, months, or years between two dates. This function is provided for compatibility with Lotus 1-2-3. Syntax DATEDIF ( start_date , e...
SharePoint Foundation 2010 , SharePoint Server 2010
DAYS360 function
Article Returns the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations. Use this function to...
SharePoint Foundation 2010 , SharePoint Server 2010
DAY function
Article Returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31. Syntax DAY ( serial_number ) Serial_number   is ...
SharePoint Foundation 2010 , SharePoint Server 2010
TIMEVALUE function
Article Returns the decimal number of the time represented by a text string. The decimal number is a value ranging from 0 (zero) to 0.99999999, representing the times f...
SharePoint Foundation 2010 , SharePoint Server 2010
MONTH function
Article Returns the month of a date represented by a serial number. The month is given as an integer, ranging from 1 (January) to 12 (December). Syntax MONTH ( serial_n...
SharePoint Foundation 2010 , SharePoint Server 2010
Didn't find what you were looking for?Search all of Office.com