Grouping dates from the past

[matthewpaul12]

Hi,

If i list of historical dates from the past in Column A and I want to identify as either "<6 months from today", "6-11 months from today", or "12+ months from today", how should I write the formula? I am having trouble.

Thanks!

 

[Joe4]

Take a look at incorporating the DATEDIF function.
See: https://support.office.com/en-us/ar...wo-dates-8235e7c9-b430-44ca-9425-46100a162f38