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.


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.

Sample File

Ali’s Website