Hi,

There are probably many ways of doing this. Which one you go for will very much depend on your specific project.

Are you looking for a Formula approach or a VBA approach?

Would the names go to the bottom of the list in the order you add the dates or the order of the dates themselves?
If the dates are added in chronological order then this wont be an issue as it will effectively be the same thing, but if you are likely to jump back and forward with dates when you enter them then it will make a difference to the approach taken.

BSB.