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

N

Nath

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using dates for lookup 2
accounts payable aging report 4
Conditional Formating for dates beyond 30, 60, 90 to be high light 3
Conditional Formatting with Icon Sets 0
How to add 30, 60 and 90 days to date and calculate deepening disc 5
Format the columns 30 - 60 - 90 -120 5
SUMIF with date ranges 2
Excel Formula - Count Dates from another Sheet 8

Top