Microsoft Office Forums - View Single Post - Formula to return a value of 1,2,3 or based on a set criteria

Thread: Formula to return a value of 1,2,3 or based on a set criteria

View Single Post

Old

06-02-2017, 01:17 PM

Highlander01 Highlander01 is offline

Highlander01 is offline

Highlander01 uses Windows 10

Windows 10 Highlander01 uses Office 2016

Highlander01 uses Office 2016

Office 2016

Novice

The original poster

Join Date: Jan 2016

Location: Portsmouth, England

Posts: 18

Highlander01 is on a distinguished road

Default

Quote:

Originally Posted by NBVC

View Post

Like this:

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

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

Appreciated!

Gordon

Reply With Quote