Forum Discussion

BrianPierron's avatar
BrianPierron
Qrew Trainee
7 years ago

Help with date formula to display next appointment date

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 disp...
Formulas and functions
AroofShaik's avatar
AroofShaik
Qrew Trainee
7 years ago
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.