S
setoFairfax
I am working on a worksheet to keep track of and display employee's leave.
On one sheet, I enter a new record into a list that contains in Column A)
Employee Name, B) Start of Leave, C) Number of Days, D) Number of Hours, E)
Type, F) End Date.
On another sheet, I have a leave calendar, spanning 4 weeks. I can enter
the start date, and I have it set up so that the dates line up with the
proper days (Mon, Tues, etc) automatically, so dates are calculated, not
constant.
On this sheet, there is a list of all personnel's names in Column A. In Row
5, the dates run across the sheet.
What I need it to do is to place a mark in the cell corresponding to a date
and name if that person is on leave for that day. I have been unable to
write a formula that does this based on the information from the list sheet.
Can anyone offer any suggestions? Thanks!
On one sheet, I enter a new record into a list that contains in Column A)
Employee Name, B) Start of Leave, C) Number of Days, D) Number of Hours, E)
Type, F) End Date.
On another sheet, I have a leave calendar, spanning 4 weeks. I can enter
the start date, and I have it set up so that the dates line up with the
proper days (Mon, Tues, etc) automatically, so dates are calculated, not
constant.
On this sheet, there is a list of all personnel's names in Column A. In Row
5, the dates run across the sheet.
What I need it to do is to place a mark in the cell corresponding to a date
and name if that person is on leave for that day. I have been unable to
write a formula that does this based on the information from the list sheet.
Can anyone offer any suggestions? Thanks!