I have 10 date fields to list appointment dates in chronological order. We can call them appointment 1, appointment 2, appointment 3, etc. I would like to create one formula date field that would display the date in appointment 2 if the date in appoint 1 is prior than the current date. then if appointment 2 is prior to the current date i want to display appointment 3. Does anyone have any help on writing out this type of formula?