DAYS function is introduced in Excel 2013 and it is very useful function to calculate the number of days between two dates. Syntax:- = DAYS(end_date, start_date) Example:- If we apply DAYS function to find out the number of days between … Continue reading →

COMBINA function This function has been introduced with Excel 2013. It returns the number of combinations, with repetitions, for a given number of objects. For example, out of 3 boys, the number of team consisting of 2 members can be … Continue reading →

SHEETS function With Excel 2013, Microsoft has introduced a new function viz. SHEETS This function returns the total number of sheets in reference. For example if a workbook has 5 sheets and if you write this function as shown below, … Continue reading →

Do you ever faced a situation where you need to check if a cell has a formula or not? Here is the good news.. Now we have ISFORMULA function which is available in Excel 2013. Using this formula, you can … Continue reading →

MUNIT function Munit function has been introduced with Excel 2013. It returns the unit matrix for the specifid dimension. For example, you can select a1:c3 range and while selection is there, type = Munit(3), press Ctrl + Shift + Enter and … Continue reading →

RRI function RRI function has been introduced with Excel 2013. It returns the interest rate for the growth of an given investment based on it’s present value and future value for a given period. For example, to know what would … Continue reading →

Excel 2013 has given a function to fetch data from web (internet or intranet), which is know as WEBSERVICE As name suggests, this function can be used to get data from a webservice. Syntax:- WEBSERVICE(url]) where url is … Continue reading →

BITOR function This function has been introduced with Excel 2013 and it returns bit-wise “OR” of 2 numbers. For example, binary representation of 3 is 11 and for 10 it is 1010 and we can check that we have 1 … Continue reading →

UNICODE is a new function introduced in Excel 2013. This function is used to return the code number of the first character of the text in reference. Syntax:- UNICODE(text) where text is the character string for which you need the … Continue reading →

GAMMA function has been introduced with Excel 2013. This function returns the Gamma function value. Syntax:- =GAMMA (number) Note:- GAMMA uses the following equation: Ð“(N+1) = N * Ð“(N) If the number is zero or negative, function returns … Continue reading →