N Nath Jul 14, 2009 #1 Hi, How do I calculated between two dates to return the value as 30, 60, 90 day.
N Nath Jul 14, 2009 #2 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+
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+
J Jacob Skaria Jul 14, 2009 #3 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
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