Date Range
You probably didn't see my post while you were compiling your second
one.
Pete
On Dec 5, 4:32*pm, Beth wrote:
Hi Everyone
I have done this with nested IF statements.
If there is a better way to do this please let me know!
Kind Regards,
Beth
"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- Hide quoted text -
- Show quoted text -
|