These functions will return the number of days between two dates
Category: Microsoft Excel Functions tutorial
HOUR , MINUTE and SECOND functions in Excel
These functions will extract a hour , minute or second value from a time serial number in Excel as integer number
YEAR , MONTH and DAY functions in Excel
These functions will extract a year, month or day value from a date serial number in Excel as integer number
TODAY and NOW functions in Excel
TODAY and NOW functions return current time of your system and will keep it update in your Excel file:
TIME function in Excel
TIME function return a time value based on there separate numbers which should be entered to function as hour, minute and second
HYPERLINK function in Excel
HYPERLINK function will generate a clickable link to website, a file in hardware or a cell in a sheet
Date Function in Excel
DATE function will get number values referring to year, month and day and then return the date value
OFFSET function in Excel
OFFSET function return a cell or range based on distance from a reference cell
ADDRESS function in Excel
By giving the row and column number to ADDRESS function, it will return the reference of that particular cell as text string that can be used in other formulas.
INDIRECT function in Excel
This function will return cell value of specific text that refers to cell address. In this video we talk about Indirect function in Excel and will see some examples of how to use this function