There is a number of ways for calculating the difference between two dates in Excel. You may get the number of days, months and years by using these ways along with adding or subtracting and getting the resultant dates.
The Excel REPLACE and SUBSTITUTE functions can be used for replacing new text string by existing text in the given text. See the examples, syntax, and difference between these two functions by this tutorial.
The Excel has a number of functions that enable rounding the decimal numbers as per the need. These functions are: ROUND
ROUNDUP, ROUNDDOWN and MROUND
The Horizontal lookup function, HLOOKUP in excel is used to find the specific value in a row for the table that is arranged horizontally.
Formulas to Calculate Age in Excel In Excel, you may calculate the age in a…
The Excel DATEDIF function takes the start date, end date, unit and calculates the difference in terms of days, months or years between these two dates. The unit specifies what you require; days, month, or years.
The FIND is case sensitive to return the position. The ‘C’ and ‘c’ has different meanings if you use FIND method to get the position of text in source string. The SEARCH function is case-insensitive. You may not use the ‘*’ and ‘?’ wildcards in the FIND function.
In this tutorial, I will show you step by step of how to find the duplicate data in rows/columns. This is followed by steps for deleting the duplicate data.
The Excel MACTH function returns the relative position of the specified item from the given range of cells. This is how the MATCH function can be used:
The Excel simple IF function enables us to test a condition and returns True or…
The IFERROR function enables us to trap and handle the errors that occur in functions or use it independently. You may display descriptive messages e.g. “0 is not allowed” etc.
The IF statement is generally taken as a decision making statement. In Excel, the IF is a function that enables us doing that.
the VLOOKUP in Excel is used to “look up” or find a value in a table. The V in VLOOKUP function stands for Vertical. That means the VLOOKUP function works for data organized vertically.
Use the Microsoft Excel COUNTIF function (a statistical function) that is used to count the number of cells for the given criterion.
4 Examples to Learn Excel / VBA DateDiff Function 
MS Excel Statistics – Usage by Job, Country, Industry & App Downloads 
How to Get Length of String by VBA Len function? 
How to Close Excel Workbook using VBA Code 
How to Create New Excel Workbook using VBA 
