Calculate new date by adding number of days to existing date (excluding weekends and pub holidays)? | XM Community
Skip to main content
Question

Calculate new date by adding number of days to existing date (excluding weekends and pub holidays)?

  • 27 June 2019
  • 0 replies
  • 41 views

Dear Community,



I'm trying to create the following 3 separate fields:

1. Input field that allows selection of an original date in the format DD/MM/YY (ideally using flatpickr, https://flatpickr.js.org/), and _only_ working days (i.e., no weekends or public holidays)

2. Drop-down menu (or otherwise restricted choice field) that allows for a choice of numbers between 1 and 10 inclusive (to indicate number working days)

3. A new date output in the format DD/MM/YY that adds the number of working days (specified in the previous field) to the original date, _excluding_ weekends and public holidays



E.g.,

Original date: 31/07/19

Number of working days: 3

New date: 05/08/19



Does anybody know how I might achieve this in Javascript with flatpickr?
Be the first to reply!

Leave a Reply