It goes like this:
08/01/87 thru 07/31/88 = U-18
08/01/88 thru 07/31/89 = U-17
08/01/89 thru 07/31/90 = U-16
08/01/90 thru 07/31/91 = U-15
08/01/91 thru 07/31/92 = U-14
08/01/92 thru 07/31/93 = U-13
08/01/93 thru 07/31/94 = U-12
08/01/94 thru 07/31/95 = U-11
08/01/95 thru 07/31/96 = U-10
08/01/96 thru 07/31/97 = U-9
08/01/97 thru 07/31/98 = U-8
08/01/98 thru 07/31/99 = U-7
08/01/99 thru 07/31/00 = U-6
08/01/00 thru 07/31/01 = U-5
08/01/01 thru 07/31/02 = U-4

Thanks for Everyones Help!!!!
Scott




Biff Wrote:
I have ranges from U-4 to U-18.

Does that mean you also have a date range for each U value?

If so, then you're best approach would be to build a lookup table.

Post back with all the ranges and their corresponding values.

Biff

"ScottEslick"

wrote in message
...

I have a small deal I can't figure if I can do... I want
to
return a value for a date in a specific range of dates, is this
possible?

TIA,
Scott


--
ScottEslick

------------------------------------------------------------------------
ScottEslick's Profile:
http://www.excelforum.com/member.php...o&userid=30622
View this thread:
http://www.excelforum.com/showthread...hreadid=502755



--
ScottEslick
------------------------------------------------------------------------
ScottEslick's Profile: http://www.excelforum.com/member.php...o&userid=30622
View this thread: http://www.excelforum.com/showthread...hreadid=502755