G
ganga
Hi,
I have 2 work books. One is weekly schedule and other one is yearly vacation
schedule. I would like to link both books matching names and dates. Vacation
schedule is in monthly format and weekly schedule is in weekly format.
Eg: yearly vacation schdule
jan 1 Jan 2 Jan 3 and so on
ram siva
ganga
weekly schedule
jan 1 Jan 2 Jan 3
ram off 10-6 9-5
ganga off 9-5 11-7
siva 10-6 off 9-5
I need a formula in weekly schedule saying that if the date and name match
in yearly schdule says “off†otherwise shift time.
Thank you in advance
I have 2 work books. One is weekly schedule and other one is yearly vacation
schedule. I would like to link both books matching names and dates. Vacation
schedule is in monthly format and weekly schedule is in weekly format.
Eg: yearly vacation schdule
jan 1 Jan 2 Jan 3 and so on
ram siva
ganga
weekly schedule
jan 1 Jan 2 Jan 3
ram off 10-6 9-5
ganga off 9-5 11-7
siva 10-6 off 9-5
I need a formula in weekly schedule saying that if the date and name match
in yearly schdule says “off†otherwise shift time.
Thank you in advance