MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Working with Dates


January 21, 2002 - by Juan Pablo Gonzalez

Jorge asks:

Please, how can I fill a column with the last date of the month, starting with the last date of one particular month?  I've tried filling series, but if I start for instance with 30-june-2002, the following cell will be 30-july-2002 but not 31-july-2002 that is the one I need, and so on. Thank you.

To do this you’ll have to use a formula. If the starting date (30-june-2002) is in A2, put this formula in A3 and drag down.

=DATE(YEAR(A2),MONTH(A2)+2,0)