The Ultimate Guide How to Use Excel Better

Excel DATEVALUE Function

What is the Excel DATEVALUE Function? The DATEVALUE function converts a text representation of a date into a proper excel date (a serial number recognized as a date by Excel). Proper excel DATE is more useful than a date represented as text when you want to …

Full Article

Excel SUMPRODUCT Function

What is SUMPRODUCT Function? The SUMPRODUCT function multiplies corresponding ranges or arrays and returns the sum of those products. SUMPRODUCT Syntax SUMPRODUCT(array1, , , ...) array1, required. The first data to be multiplied, then sum. , optional. The second data to be multiplied, then sum. Usage …

Full Article

How to Subtract in Excel

Subtraction Formula Using the Minus Sign “-“ The symbol used for the subtraction formula is a minus sign “-” as well as a sign used in a mathematical operation. You can type the numbers involved in the subtraction directly in the formula or place the numbers …

Full Article

Excel DATEDIF Function

What is the DATEDIF function? The Excel DATEDIF function calculates the number of days, months or years between two dates. The Excel DATEDIF function is an undocumented function, even though in newer Excel versions you can find the DATEDIF function documentation in the Excel help menu. …

Full Article