Date Range
I assume you are comparing those dates (assumed to be in column A)
with today's date. If so, then set up your table like this:
0 0-34 days
35 35-69 days
70 70-104 days
105 105-139 days
140 140+
Suppose this occupies L1:M5, then put this formula in B1:
=VLOOKUP(TODAY()-A1,L$1:M$5,2)
and copy down. I've assumed that your dates are all older than today,
but if they are dates in the future then you will need to change it
to:
=VLOOKUP(A1-TODAY(),L$1:M$5,2)
Hope this helps.
Pete
On Dec 5, 4:10*pm, Beth wrote:
Hello,
I have got a list of dates. *For each date I want to show whether this is
0-34 days, 35-69 days, 70-104 days, 105 to 140 days or 140+
I have set up a table with the different ranges in and now need to look up
to the table.
Any ideas would be apreciated. *Thank you.
Beth
|