Help with date formula to display next appointment date

  • 0
  • 1
  • Question
  • Updated 10 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

Brian

  • 200 Points 100 badge 2x thumb

Posted 10 months ago

  • 0
  • 1
Photo of Aroof Rahaman Shaik

Aroof Rahaman Shaik

  • 152 Points 100 badge 2x thumb
Hi, 
 You can use 

 Workdays formula for calculating next appoint date.

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

Ex.

 If your taking appointment date for next week in working day 


Syntax 

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.



Brian,
The formula for [Next Appointment Date] would be

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

etc

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