Excel Dates table help

I would like to create a table for license expiry on vehicles.

A1 Down – Reg numbers of fleet vehicles.

A1 Across – Months.

I want to only have one table in the spreadsheet but I would like to have the option of changing year. 

For Example.

C5 Reg 12345 shows license renewed on 29th Feb 18.

I would like a green row line upto the next renewal date in 2019 which would show when selecting 2019 table.


Sorry it is hard to describe. 

To try and cut it short, 

  • Have one table
  • Use multiple years
  • Years to be connected
  • Is there a date ranges option in Excel?



By: Ian

Leave a Reply

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