Always Refer to Cell A1

If you need to ALWAYS refer to cell A1, regardless of whether row or columns are inserted or deleted, then use the following formula.


This will always display the entry in cell A1 on the current sheet.

Another formula that always refers to cell A1 on the current sheet is


Days in Month Formula

If you need to calculate how many days in a month, you can use two functions together.

Assuming cell A1 has a date within the month, you can use



The Problem with the MROUND Function

The ROUND function rounds values to decimals places on either side of the decimal point. It is useful and popular. The MROUND function is meant to allow you more flexibility in your rounding calculations. Let’s say you want round to closest 0.05. The MROUND is meant to handle this calculation but unfortunately it provides inconsistent results.