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.
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?