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