Custom Function to Increment Dates
Excel can easily add days to a date but months, quarters and years require a slightly different calculation. Here’s a single function that does all three.
(more…)Excel Custom Function for Common Dates
Excel has an EOMONTH function that returns the end of month. You can hack this function to return the start of the month as well. I thought I would make it easy to return the first, last or middle of the month in one simple function.
(more…)Sequential Rank Custom Function for Excel
Excel does not have a rank function that returns sequential numbers. All Excel’s ranking functions can return duplicated ranking numbers. Here is a solution to creating a sequential ranking system with no duplicates.
(more…)Formatted Table Running Total Custom Function
I have shared a running total formula for a formatted table many years ago. Here is a better solution that I have converted into a custom function.
(more…)Identifying Locked Cells in Excel
The default setting in Excel is for all cells to be locked. If you want users to input in a cell you must unlock that cell before you apply sheet protection. You can use a formula to identify locked and unlocked cells.
(more…)