Date & Time : Calculating the end-of-month
A commonly needed entity is the date of the last day of a particular month or a range of months, usually when payments are due or when interest is calculated. We show two approaches to this.
The EOMONTH function returns the last day of the month based on the specified date and offset value. For the current month, the offset is 0 and the offset is incremented by 1 for each subsequent month - as is illustrated below.
An alternative approach is to use the DATE function. A little known feature of the DATE function is that a zero in the day argument results in the last day of the previous month being output.
The example below shows how this could be implemented.
September 10th, 2007 at 12:33 am
I couldn’t understand some parts of this article Time : Calculating the end-of-month, but I guess I just need to check some more resources regarding this, because it sounds interesting.