Calculate Duration between dates and return results in three groups

[typewriterguy]

Hi. Using Excel 2003,

I have two columns of start/end dates, both in mm/dd/yyyy format

Column A is a start date
Column B is an end date

I'd like to calculate the duration between ColumnA and ColumnB and return the results as shown in one of the four duration groups below.

Duration group
0-6 months
6-12 months
12-18 months
18+ months

I started with this formula (found on this board) but realize that it won't do what I need it to do (above). Any help would be appreciated. Thanks!

=INT(TEXT(B15,"[h]")/24) &" days" & TEXT(MOD(B15,1)," h:mm")

 

[Biz]

<TABLE dir=ltr border=0 cellSpacing=0 cellPadding=2 width=250><TBODY><TR><TD height=19 width="29%">Start Date

​

</TD><TD height=19 width="32%">End Date

</TD><TD height=19 width="39%">

​

</TD></TR><TR><TD height=19 width="29%">1/02/2010

​

</TD><TD height=19 width="32%">1/08/2010

​

</TD><TD height=19 width="39%">0-6 months

​

</TD></TR><TR><TD height=19 width="29%">1/02/2004

​

</TD><TD height=19 width="32%">1/09/2004

​

</TD><TD height=19 width="39%">6-12 months

​

</TD></TR><TR><TD height=19 width="29%">2/02/2004

​

</TD><TD height=19 width="32%">2/02/2005

​

</TD><TD height=19 width="39%">12-18 months

​

</TD></TR><TR><TD height=19 width="29%">3/02/2004

​

</TD><TD height=19 width="32%">3/08/2005

​

</TD><TD height=19 width="39%">18+ months

​

</TD></TR><TR><TD height=19 width="29%">4/02/2004

​

</TD><TD height=19 width="32%">4/10/2005

​

</TD><TD height=19 width="39%">18+ months

</TD></TR></TBODY></TABLE>​

Try formula 1

=VLOOKUP(--DATEDIF(A2,B2,"m"),{6,"0-6 months";7,"6-12 months";12,"12-18 months";18,"18+ months"},2,1)

or Formula 2
=LOOKUP(--DATEDIF(A2,B2,"m"),{6,"0-6 months";7,"6-12 months";12,"12-18 months";18,"18+ months"})

Both formulas derive the same results.

Biz