In attachment is how I would do it.
On sheet People is list of people with DOB. The column RowNo is needed for calculations and is meant to be hidden.
On sheet Birthdays, user enters a date from which the list of next birthdays is displayed, and sorts the birthdays table by Next BD.
|