Reputation: 19
I have used this formula =DATE(2024; SEQUENCE(12);2)
to get a table of 12 months sequential dates. I use this data for updating validity range in Excel that depends on sequence of months from the current. I have updated the ranges well for the current month based on dates from the table, but would wish to have these ranges updated automatically.
I have this table 02/Jan/24
up to 02/Dec/24
in columns AC13 to AC24, from this would like to have cell AD4 which is equal to AC13 in Jan 2024 to automatically change to A14 in Feb 2024 and so forth.
Upvotes: 0
Views: 52