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.
MONTHLY DATE INCREMENT
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.