C
cathy
I have a spreadsheet with all employees last names in column "A", their
first names in column "B" and their date of hire in column "C". Rows E - Q
are allocated to "Illnesses 200" listing each month "jan - dec" in a separate
column. The same format is done for "Personal Days", "Vacation Days" etc. I
have 2008 data first followed by 2007 data.
So, when you look at "John Doe" in row 7 - you will see he took one sick day
in January 2008, 3 sick days in March 2008 and 2 sick days in Nov 2007. If
his date of hire is Dec 1,2002 I want to calculate how many sick days he took
as of his anniversary data (Dec 1,2007).
How can I calculate this? Thank you.
first names in column "B" and their date of hire in column "C". Rows E - Q
are allocated to "Illnesses 200" listing each month "jan - dec" in a separate
column. The same format is done for "Personal Days", "Vacation Days" etc. I
have 2008 data first followed by 2007 data.
So, when you look at "John Doe" in row 7 - you will see he took one sick day
in January 2008, 3 sick days in March 2008 and 2 sick days in Nov 2007. If
his date of hire is Dec 1,2002 I want to calculate how many sick days he took
as of his anniversary data (Dec 1,2007).
How can I calculate this? Thank you.