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