Formula Suggestion required
I have a table with the following information
Pay Date End Period
07-09-2006 0809
05-10-2006 0909
02-11-2006 1009
30-11-2006 1109
21-12-2006 1209
What I want to be able to do is enter a date for example 15/11/2006, and it
tell me what the end period would be. Therefore it would look for the first
higher paydate, in this case 30/11/2006 so therefore return a value of 1109.
Many Thanks in advance for your assistance
|