There may be better ways but I would use a helper column.

Insert a new Column B. In B1 enter the formula:

=IF(A1<"",1,"")

In B2 enter:

=IF(OR(AND(A2<"",A3=""),AND(A1="",A2<"")),COUNTI F($B$1:B1,"<"&"")+1,"")

and copy down to B30

In B31 enter:

=IF(A31<"",31,"")

In A32 enter:

=IF(COUNT(B1:B31)=(ROW()-ROW($A$31)),LARGE($B$1:$B$31,COUNT($B$1:$B$31)-(ROW()-ROW($A$32))),"")

and copy down as far as you require, (it will work for as many different
periods as you want)

Note: if someone comes in for one day, it will only return one number not 2.

You can then hide Column B

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Therese" wrote in message
...
Hi
Thank you, this works very fine for the ones who only comes in once a
month.
But will I be able to maybe combinate this formular with another, so that
I
can get all four numbers...like : A32=14 A33=22 A34=28 A35=30 If Anne
comes
in from 14th may to 22nd may, and the she comes again from 28th may to the
30th. As it is for now, A32=14 and A33=30 in the above example.
Therese

"Max" wrote:

Perhaps something simple like this ?
(it assumes you have numbers as per your ps within row 2 to row 31)

In A32: =MIN(A2:A31)
In A33: =MAX(A2:A32)
Select A32:A33, copy across as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Therese" wrote:
Well....the numbers changes downwards.
We have a rather large list of names and the numbers varies from name
to
name...The persons comes in different days in the month. Clara comes
from the
14th to the 19th, Dora from th 12th to the 13th etc.
Some comes in twice, but that may be too dificult, don't you think?
Do you think you can work it out ?

Ps. They are just numbers. The worksheet is called may.

Thanks
Therese