"the number of day the term falls under" what?
If you mean from today, you want something like:
=if(today()-a2365,"365+",if(today()-a2=180,"=180",if(today()-a2=90,"=90",if(today()-a2=60,"=60",if(today()-a2=30,"=30","Current")))))

Regards,
Fred

"Aging Termination Dates" <Aging Termination
wrote in message
...
What is the formula to show terminations that falls under 30,60,90,180 and
365+

Column A is Term Date Column B should be the number of day the term falls
under
A B

Termination Date Catagory
06/17/2009 =180
10/01/2009 =60
02/21/2009 (need formula to show this)
05/19/2009
09/15/2009
01/07/2009
05/31/2009
03/02/2009