To enter the last day of every month into a column in a worksheet, first enter the last date of the first month to be included, say 31/01/2017.
Drag down to fill in as many as required. Go to the Autofill Options button at the bottom and choose Fill Months. The last date of each month will be entered as required.
Find out more about our Microsoft Excel training London, UK.
Find out more about our Microsoft Excel training Wiltshire, Hampshire, Dorset.