Excel: Calculate last date of a specific month

Popular categories

Dashboard reporting with excel This e-book teaches you how to create your own Excel dashboard reports, starting from scratch. Learn how to create mini-charts, how to use Excel's Camera tool, how to set up Excel databases, and a lot more.

Excel Worksheet-Formula Add-Ins allows worksheet formulas to change chart settings. For the first time ever, your formulas can create traffic-light charts, highlight chart elements, assign number formats, and much more.

Get Digital Help > Excel > Excel: Calculate last date of a specific month

← Previous post -

Filed in Excel on Sep.13, 2007. Email This article to a Friend

Question: Calculate the last day of a month?

Answer: We need a starting date, in this case 2007-01-01. To calculate the last day of the starting month we use this formula: =DATE(YEAR(A2),MONTH(A2)+1,0).

So a zero in DATE(year,month,0) returns the last day in the previous month, that is the trick!

YEAR(serial_number) returns the year of a date, an integer of the range 1900-9999

MONTH(serial_number) returns the month, a number from 1 (January) to 12 (December

DATE(year,month,day) returns the number that represents the datein Microsoft Office Excel date-time code