Use the EOMONTH function to determine the last day of a month
To find the last day of a month, use the EOMONTH function: (EOMONTH(start_date, offset_months)).
This function returns the date of the last day of the month, offset_months from start_date. If you try to use this function and it doesn’t work, you may need to load the Analysis ToolPak add-in. In Excel 2003, Select Add-Ins… from the [...]
Convert negative values to positive using Excel
For this tutorial, we are presented with a workbook that has a list of values that we would like to convert from negative to positive. To do this, we are going to use a quick and easy method. Read on to find out how.
How to convert negative values to positive values - Excel 97, 2003, [...]
