Categorise dates by time since created

Hi All

I have a spreadsheet (CSV file) that I download once a week that gives me a date an event was created, but what I need to do is categorise these dates by the length of times since they were created.

i.e

Column A1 to A267 lists the dates

What I would like in column D1 to D267 is based on column A: less than 3 months,less than 6 months, between 6 & 12 months, between 12 & 24 months, between 24 & 36 months, between 36 & 48 months, between 48 & 60 months, more than 60 months.

The wording can be altered to suit, what I am looking for is a formula to be able to categorise at least 5 different date periods.

I have searched a number of different formulas and its seems a nested If statement would work, but what I am not sure of is the best approach, was thinking of creating another column to simply count days since date created and then based on this columns figure have another column with the above categories, but it would be cleaner if possible to have it all in one column based on dates downloaded in column A.

Finally I would like to have a button on the page that would run this formula each time I copy in the data, from what I have read this would be a macro, I have done simple VBA in the past and have understanding of how macros functions work and coding of buttons to run macros, its just getting a formula into a macro to do this.

Any advice / direction would be appreciated

Never thought of it this way and only last Friday was I working with the Vlookup function for another piece of work.....Will give it a go, as I am copying the downloaded data across each week would there be any value in having this in a macro so that I do not overwrite the formulas each time I copy data in and instead press a command button to run the formulas each time.

Assuming a month is 30 days, then you could use this formula in D1:

="Less than "&INDEX({3,6,12,24,36,48},MATCH(INT((TODAY()-A1)/30)+1,{0,3,6,12,24,36}))&" months"

then copy down. If your new data is only over-writing column A, then the formulae will remain intact.

Hope this helps.

Pete