calculating vacation - working every day 12 h shifts - adding religious holidays

Hy,

=IFERROR(WORKDAY(WORKDAY(EDATE(B20;0);-1);C20;$I$20:$I$28);"enter first day of vacation")

B20 - begining (date); C20 - number of vacation days(number); I20-I28 non working days - holidays(date);

whit this formula I'm calculating vacation for employees according to inserted beginning an days of vacation (it excludes holidays and the last weekend of vacation)


I need to add one more date to it, religious holiday, different for each employee, that prolongates the vacation for one day, if it's within vacation date and if it is not a weekday (sun, sat)

how to do that?

Thanks

It might be best to upload an example of what you are trying to achieve

This is the method I have always used to upload files.

click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

=IFERROR(WORKDAY(WORKDAY(EDATE(B20;0);-1);C20;$I$20:$I$28)+IF(AND(IF(AND(WEEKDAY(E20)<>1;WEEKDAY(E20)<>7);E20;0)>=B20;IF(AND(WEEKDAY(E20)<>1;WEEKDAY(E20)<>7);E20;0)<=D20);1;0);"enter first day of vacation")

i did it like this (but i have two cels: without religious holiday and with it)

..............

needs to be added an extra day into vacation only for employees that celebrates that perticular religious holiday an if its between the begining and end of employees vacation.. Its not added if it falls on Saturday or Sunday. Employees select the begining of vacation and the number of days.Vacation can not start on weekday

thanks

how can i calculate, for each day in a year, how much employees are away based on their vacation?

Ex.
300 employees,
begining of vacation for each one
end of vacation for each one
i need to calculate how many.., number of employees that are apsent for each day of a year to make a chart
relgious holiday is just one day, that employee can take, witch, if falls between vacation date extends vacation for one day.