The "Current Plan" is the formula I'm trying to create:
Starting Point:
1 A B C D
2 NAME PLAN Effective Date Current Plan
3 ---- ---- -------------- ------------
4 ID1 1 1/1/2005
5 ID1 3 2/1/2005
6 ID2 2 5/1/2004
7 ID3 2 2/1/2005
8 ID3 4 9/1/2005
9
10 AS OF DATE:
11 3/1/2005
What I'm trying to get to is the "Current Plan" based on the "AS OF
DATE" I put in.
Ending Point:
1 A B C D
2 NAME PLAN Effective Date Current Plan
3 ---- ---- -------------- ------------
4 ID1 1 1/1/2005
5 ID1 3 2/1/2005 3
6 ID2 2 5/1/2004 2
7 ID3 2 2/1/2005
8 ID3 4 9/1/2005 4
9
10 AS OF DATE:
11 3/1/2005
I figure I need some sort of between formual or a "<" but ">" formula.
Can anyone help?
Thanks.
Tysone
Bookmarks