Termination within number of days
Since the lookup array and result array are same you can use the below for
the 1st formula
="=" & LOOKUP(TODAY()-A2,{30,60,90,180,365})
--
Jacob
"Jacob Skaria" wrote:
Try
="=" & LOOKUP(TODAY()-A2,{30,60,90,180,365},{30,60,90,180,365})
OR
="" & DATEDIF(A2,TODAY(),"m")*30
--
Jacob
"Aging Termination Dates" wrote:
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
|