Display a date in autofill if there’s a 31st in the month

I’m making a spreadsheet that has an autofill date column that will be generic for all months, so there will be 31 days. However I do not want it to display the date in the last row for months that don’t have 31 days (or the last 3 rows for february with 28 days). How can I use excel functions to only display days of the selected month without going into the next month?

By: Jonathan

Leave a Reply

Your email address will not be published. Required fields are marked *