Working with Dates
January 21, 2002 - by Juan Pablo Gonzalez
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.