Help with date formula to display next appointment date

  • 0
  • 1
  • Question
  • Updated 8 months ago
  • In Progress
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?
Photo of Brian


  • 180 Points 100 badge 2x thumb

Posted 8 months ago

  • 0
  • 1
Photo of Aroof Rahaman Shaik

Aroof Rahaman Shaik

  • 152 Points 100 badge 2x thumb
 You can use 

 Workdays formula for calculating next appoint date.

WeekDayAdd([Start Date],[Business Days]).


 If your taking appointment date for next week in working day 


Start date : 05-Sep-2018

business day : +5( it will calculate next 5 working date from calendar )

>> 12-Sep -2018 display as next five working date.

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,348 Points 50k badge 2x thumb
The formula for [Next Appointment Date] would be

[Appointment 1] > Today(), [Appointment 1],
[Appointment 2] > Today(), [Appointment 2],
[Appointment 3] > Today(), [Appointment 3],


[Appointment 10] > Today(), [Appointment 10])