Hi all,

I have a whole lot of customer data in excel that I am trying to group into categories based on criteria in other cells.

Does anyone know of a formula to be able to do this?

"Newbie" - registration date is less than 2 months old =IF(EDATE(I2,2)>TODAY(),"Newbie")
"Freeloader" - customer is not a "Newbie" and cells M, O , and P are blank.
"Packer" - customer is not a "Newbie" and the date in cell M is less than 2 months from today AND cells O and P are blank or greater than 2 months from today

Any ideas?