47. Excel Tips - Calculate the LAST Day of the month
This is a follow-on from tip on how to calculate the 1st day of the month in Excel
Suppose we want to calculate the last day of the month... can we use the same function ?
YES, but we need to be a bit more cunning this time.
- will return the last day of the month.
- it is basically saying take the 1st day of NEXT month, and subtract 1 day.
It Even works for leap years.
Training video on calculating the last day of the month in Excel: