Leave Application

is there any possibility to create a flow like:
Late say, Employee A (Technician have off day on Gazetted Holiday, Sunday, and HALF DAY Saturday)

Employee B (Officer have off day on Gazetted Holiday, Sunday and Saturday)

If let say.

Employee A and B applied for 1st Jan 2025 until 6th Jan 2025 , no of day counted differently.
Employee A should turn up 3.5 days and Employee B should turn up 3 days.

You could define two different work schedules, and assign each employee the appropriate schedule. And then reference those when doing calculations/validations/etc.

but how we actually did 1/1/25 is within 1/1/25 - 6/1/25 with sum 1 (gazetted holiday)

I try to reword your post to this, can you confirm this is what you want?

We have two employees with different off-day schedules:

  • Employee A (Technician):
    • Off days: Gazetted Holidays, Sundays, and Half-day on Saturdays.
  • Employee B (Officer):
    • Off days: Gazetted Holidays, Sundays, and Saturdays.

Application for Leave:

  • Both employees applied for leave from 1st January 2025 to 6th January 2025.

Calculation of Working Days:

  • Employee A should be present for 3.5 days.
  • Employee B should be present for 3 days.

1/Do you have a list of Gazetted Holidays in your Glide data?
2/What if the Gazette Holiday is on Saturday? Does Employee A have the full day off?

Yes, both should be considered,

  1. I do have Gazetted Holidays in my Glide data.
  2. If Gazetted Holiday on Saturday, technician have full day off. You said right.