Calculate Date Difference excluding Weekend and Holidays

Avinash Dubey2
Tera Contributor

Hi , 

I have created a service catalog in that :

I want to calculate Total Days from start date  and end date excluding weekends and holidays.

 

3 REPLIES 3

Jaspal Singh
Mega Patron
Mega Patron

Hi Avinash,

Considering you have working schedules defined you can follow link that has a working solution.

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

check the link shared by Jaspal and it should help you.

Please share the updates if stuck

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Deepti Singh Ba
Tera Expert

@Ankur Bawiskar @Jaspal Singh If I have to create the schedule what steps I should take can you please guide me on building the schedule ?