Excel functions

DAYS360 Function in Excel - formula returns the number of days between two dates based on a 360 day year. Learn Formulas, Excel and VBA with examples.

DATEVALUE Function in Excel - formula Converts a date represented by text to a serial number for a date. Learn Formulas, Excel and VBA with examples .

SUBSTITUTE Function in Excel - formula replaces old text with new text, in a text string or cell reference. It will replace all instances of the old text, unless a specific instance number is selected.

What is the use of TIME function? Returns the number [...]

DATE Function in Excel - formula returns the number that represents the particular date. Learn Formulas, Excel and VBA with examples in our free tutorials.

OFFSET Function in Excel - formula returns a reference to a range of cells that is a specified number of rows and columns from an initial supplied range

COLUMN Function in Excel - formula returns the column number of the given reference. Learn Formulas, Excel and VBA with examples in our free tutorials.

ROW Function in Excel - fromula returns the row number of the given reference. Learn Formulas, Excel and VBA concepts with examples in our free tutorials.

CELL Function in Excel - formula returns information about the contents, formatting or location of a given cell. Learn Formulas, Excel and VBA with examples

VALUE Function in Excel - formula helps to convert a number in a text format into a number format. Learn Formulas, Excel and VBA examples free tutorials.

REPT Function in Excel - formula returns a repeated text value a specified number of times. Learn Formulas, Excel and VBA examples in our free tutorials.

LEN Function in Excel - formula Returns the length of the specified string. Learn Formulas, Excel and VBA with examples explained in our free tutorials.