Date & Time Functions are used to insert current Date , Month , Week , Day , Hour , Minute , and Seconds in Excel Spreadsheet . These functions are also useful to find current Date & Time in excel spreadsheet .
Date & Time Function
There are total 24 Date & Time function in MS Excel . These 24 Date & Time functions are given below :
1.) DATE :Returns the number that represents the date in Microsoft Excel date-time code .
2.) DATEVALUE :Converts a date in the form of text to a number that represents the date in Microsoft Excel date-time code .
3.) DAY :Returns the day of the month , a number from 1 to 31 .
4.) DAYS :Returns the number of days between the two dates .
5.) DAYS360 :Returns the number of days between two dates based on a 360- day year ( twelve 30-day months ).
6.) EDATE :Returns the serial number of the date that is the indicated number of months before or after the start date .
7.) EOMONTH :Returns the serial number of the last day of the month before or after a specified number of months .
8.) HOUR :Returns the hour as a number from 0 (12:00 A.M.) to 23(11:00 P.M.) .
9.) ISOWEEKNUM : Returns the ISO week number in the year for a given date .
10.) MINUTE : Returns the minute , a number from 0-59 .
11.) MONTH : Returns the month , a number from 1 (January) to 12 ( December ) .
12.) NETWORKDAYS : Returns the number of whole workdays between two dates .
13.) NETWORKDAYS.INTL : Returns the number of whole workdays between the two dates with custom weekend parameters .
14.) NOW :Returns the current date and time formatted as a date and time . This function takes no arguments .
15.) SECOND :Returns the second , a number from 0 to 59 .
16.) TIME :Converts hours , minutes , and seconds given as numbers to an Excel serial number, formatted with a time format . Hour is a number from 0 to 23 representing the hour .
17.) TIMEVALUE :Converts a text time to an Excel serial number for a time , a number from 0 ( 12:00:00 AM ) to 0.999988426 ( 11:59:59 PM ) . Format the number with a time format after entering the formula .
18.) TODAY : Returns the current date formatted as a date . This function takes no arguments .
19.) WEEKDAY :Returns a number from 1 to 7 identifying the day of the week of a date .
20.) WEEKNUM :Returns the week number in the year .
21.) WORKDAY :Returns the serial number of the date before or after a specified number of workdays .
22.) WORKDAY.INTL :Returns the serial number of the date before or after a specified number of workdays with custom weekend parameters .
23.) YEAR :Returns the year of a date , an integer in the range 1900-9999 .
24.) YEARFRAC :Returns the year fraction representing the number of whole days between start_date and end_date .
Visit our blogs to know more about excel formulas & functions
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png&description=DATE & TIME FUNCTIONS IN MS EXCEL ){kind=link}
0 Comments