| Creating Dates & Times | | DATE | Returns a date, from a user-supplied year, month and day | | TIME | Returns a time, from a user-supplied hour, minute and second | | DATEVALUE | Converts a text string showing a date, to an integer that represents the date in Excel's date-time code | | TIMEVALUE | Converts a text string showing a time, to a decimal that represents the time in Excel |
| Current Date & Time | | NOW | Returns the current date & time | | TODAY | Returns today's date |
| Extracting The Components of a Time | | HOUR | Returns the hour part of a user-supplied time | | MINUTE | Returns the minute part of a user-supplied time | | SECOND | Returns the seconds part of a user-supplied time |
| Extracting The Components of a Date | | DAY | Returns the day (of the month) from a user-supplied date | | MONTH | Returns the month from a user-supplied date | | YEAR | Returns the year from a user-supplied date | | WEEKNUM | Returns an integer representing the week number (from 1 to 53) of the year from a user-supplied date | | WEEKDAY | Returns an integer representing the day of the week for a supplied date |
| | Performing Calculations with Dates | | EDATE | Returns a date that is the specified number of months before or after an initial supplied start date | | EOMONTH | Returns a date that is the last day of the month which is a specified number of months before or after an initial supplied start date | | WORKDAY | Returns a date that is a supplied number of working days (excluding weekends & holidays) ahead of a given start date | | WORKDAY.INTL | Returns a date that is a supplied number of working days (excluding weekends & holidays) ahead of a given start date, using supplied parameters to specify weekend days (New in Excel 2010) | | DAYS360 | Calculates the number of days between 2 dates, based on a 360-day year (12 x 30 months) | | NETWORKDAYS | Returns the number of whole networkdays (excluding weekends & holidays), between two supplied dates | | NETWORKDAYS.INTL | Returns the number of whole networkdays (excluding weekends & holidays), between two supplied dates, using parameters to specify weekend days (New in Excel 2010) | | YEARFRAC | Calculates the fraction of the year represented by the number of whole days between two dates |
|
No comments:
Post a Comment