david gabra
Member
Hi
I have attached a file with two tabs
Master: this show the i) employee# (column A) ii) cut-of payroll date (column B) - this is date that the payroll is paid for that month. ii)Amount paid to the employee.
Vacation: Two columns: the i) employee# (column A) ii) the dates vacation taken (column B and C)
My goals is to see if an person was paid during the time they were on holiday and the number of vacation days that appear in the payroll month.
I added a manual worked example, one additional column "Was a Vacation Taken" and for this I would like a "yes" or "no"
I have added a notes column to explain the reason behind what numbers should appear.
I hope that is clear.
Having this automated would be amazing.
Thank you
David.
I have attached a file with two tabs
Master: this show the i) employee# (column A) ii) cut-of payroll date (column B) - this is date that the payroll is paid for that month. ii)Amount paid to the employee.
Vacation: Two columns: the i) employee# (column A) ii) the dates vacation taken (column B and C)
My goals is to see if an person was paid during the time they were on holiday and the number of vacation days that appear in the payroll month.
I added a manual worked example, one additional column "Was a Vacation Taken" and for this I would like a "yes" or "no"
I have added a notes column to explain the reason behind what numbers should appear.
I hope that is clear.
Having this automated would be amazing.
Thank you
David.