When demonstrating the fill handle for series recently, I was asked whether Excel could work out the last date of each month. The answer is yes it can.
If you enter the last dates of the first two months in your series:
Now select both cells and go to the fill handle at the bottom right of the second cell.
Drag down as far as you need for your data series:
It will even recognise leap years!
Find out more about our Excel training courses Sydney, Australia.