Hi,

I would like to calculate the number of the working days.

FormA: "Submit" - will be storing the periods

Fields:

Beginning_on (date_field)

Ending_on (date_field)

Days_off (number_field)

FormB: "Calendar_master" - storing the working day info on day level

Fields:

Date (date_field) -- the whole year uploaded

Working_day (number_field) --- 0 if not working day and 1  if it is a working day

Can you please advise, how it can be automatically add in the Days_off field (Submit form) the number of the working days between the given Beginning_on date and Ending_on date (based on the Calendar master details)?

Thank you!

Ferenc