# Tag Archives: Date And Time Functions

## DATE Function in Excel, How to use DATE Function?

Function Date returns the DATE Value when we combine take 3 separate values to form a date. Date Function in Excel   Syntax of DATE function in Excel DATE(year,month,day) Date Function Example: When you’ve Year, Day, Month as seen in the above worksheet Year as 2016, Day as 18th and Month as 5. Function =DATE(G5,I5,H5) will give you… Read More »

## TIME Function in Excel, How to use TIME Function in Excel?

Function TIME accepts integer values representing hrs, mins and seconds and returns Excel time. Syntax of TIME function in Excel TIME(hour,minute,second) Example:- TIME(26,0,0) = 02:00:00 TIME(25,12,0) = 01:12:00 Hour Value If hour value is greater than 23 then Excel calculates it by dividing it by 24 and returning the remainder Example: – TIME(25,12,0) returns a value… Read More »

## Subtracting between two Dates in Excel, Minus Date from Date

Substracting two dates in Excel gives you the no of days between the given dates. You can Substract or Minus two Dates in Excel using a Today function and the Date function. The Formula calculates the no of days between the current date and the date specified in the DATE function. Substracting Dates Example: =TODAY() – DATE(2016,5,10) Returns… Read More »

## DATEVALUE – Converts Text Value into Excel Date format

DATEVALUE functions converts a date which is stored as text into a serial number which is recognized by Excel. Syntax of DATEVALUE function in Excel DATEVALUE( date_text ) Example: =DATEVALUE(“1/1/2015”) returns a number 42238 of a date. Function Requirement: Text that represents a date in an Excel date format, or a reference to a cell… Read More »

## TIMEVALUE – Converts Text Value into Excel Time format

TIMEVALUE functions converts a time which is stored as text into a decimal number which is recognized by Excel. Syntax of TIMEVALUE function in Excel TIMEVALUE(time_text) TIMEVALUE Function in Excel-ExcelBlackBook.com Example: =TIMEVALUE(“2:50 am”) returns a number 0.118055556 of time. Function Requirement: A text string that represents a time in any one of the Microsoft Excel time… Read More »