This is my useful Excel Page

This page will dedicated to useful tricks that I have learnt using Microsoft Excel. Feel free to follow the links to see the example workbooks.


This file shows two ways of achieving the same goal. What was required was a formula to increment a date monthly, but to allow for different month lengths when the date fell on or after the last day of February. The image shows both formulae working side-by-side.

Sample File

Ali’s Website