| 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 |
|
Comments
Post a Comment
jeetexceltips@gmail.com