How to write a formula to calculate the last day of the month for a given date

This article will describe a simple formula to calculate the last day of the month of any date.

The complication arises due to the fact that months may have 28, 29,30 or 31 days.

I will take you through the thought process of getting to the final formula.

Read the rest of this entry »