If you have the toolpak installed
=EOMONTH(D12,0)
if not
=DATE(YEAR(D13),MONTH(D13)+1,0)

--
Don Guillett
SalesAid Software

"Pendelfin" wrote in message
...
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