Dear Experts

Help!

I need to introduce a set of criteria in my spread sheet (Office 2010) based on a date.

I have a date in cell L5 and want to return a value of 1,2,3 or 4 in M5 based on the following criteria:
<4 months to return a value of 1
=>4 – <6 months to return a value of 2
=>6 – <12 months to return a value of 3
=>12 months to return a value of 4



Any help would be greatly appreciated

Gordon

Does this work?

=LOOKUP(DATEDIF(TODAY(),L5,"m"),{0,4,6,12},{1,2,3, 4})

WOW! Thank you so much.

I will give it a go tomorrow.

Gordon

No Problem.

If the dates in L5 are before today, then switch the L5 and TODAY() parameters...

The dates in L5 will definitely be before today, and can be anything between 3 and >12 months.

Just so I don't mess it up how would it look if I changed the parameters?

Gordon

Like this:

=LOOKUP(DATEDIF(L5,TODAY(),"m"),{0,4,6,12},{1,2,3, 4})

Excellent, thank you.

I tried this today and hey presto. Thank you very much.

Appreciated!

Gordon