These functions will extract a hour , minute or second value from a time serial number in Excel as integer number
These functions will extract a hour , minute or second value from a time serial number in Excel as integer number
These functions will extract a year, month or day value from a date serial number in Excel as integer number
TODAY and NOW functions return current time of your system and will keep it update in your Excel file:
TIME function return a time value based on there separate numbers which should be entered to function as hour, minute and second
HYPERLINK function will generate a clickable link to website, a file in hardware or a cell in a sheet
DATE function will get number values referring to year, month and day and then return the date value
OFFSET function return a cell or range based on distance from a reference cell
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.
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
Index function will return a cell value in intercept of specified row and column number in specific range