Age Date Between Two Dates to Return Value as 30, 60, 90 day

  • Thread starter Thread starter Nath
  • Start date Start date
Sorry, that did not work. I'm doing something work. What I'm looking for is:
Cell
A1 = 6/8/07
A2 = 12/11/08

I need it to return the value between the two date as 30,60,90,180,360, and
1yr+
 
Another way..

=LOOKUP(A2-A1,{0,30,60,90,180,360,361},{0,30,60,90,180,360,"1 yr+"})

If this post helps click Yes
 
Back
Top