Assigning a category to a specific time frame

**Woofaloo** · 03-15-2013, 03:45 PM

I have a spreadsheet that calculates the amount of time between 2 dates. I need to take that the years, months, and days and categorize it into one of 4 different categories, such as "< 3 months" or "3-6 months" or "7-12 months" or "1-2 years" and have that go into a separate cell. Can anyone help me with this? PLEASE!?!?!?!?!

**judgeh59** · 03-15-2013, 06:08 PM

Is this the output you are looking for? Because I wasn't sure...

**Woofaloo** · 03-18-2013, 07:52 AM

This is almost. but not using the TODAY functions. I have a begin and end date.

**benishiryo** · 03-18-2013, 08:36 AM

hi Woofaloo, welcome to the forum. you can use DATEDIF.
=IF(DATEDIF($A2,$B2,"m")<3,"X","")

DATEDIF($A2,$B2,"m")
this gives you the number of months between 2 dates. so if it's lesser than 3, show as "X".

to put in 2 ranges like 3-6, add the AND formula:
=IF(AND(DATEDIF($A2,$B2,"m")>=3,DATEDIF($A2,$B2,"m")<=6),"X","")

it's similar for the rest. for years, you can use 12 months x number of years or use DATEDIF(($A2,$B2,"y")