need help with formula

G

grizzly6969

I use this formula for vacation

=IF(LEFT(UPPER('[employee Calendar..xls]2009'!B18),1)="V",'[employee
Calendar..xls]2009'!A1&" "&SUBSTITUTE(UPPER('[employee
Calendar..xls]2009'!B18),"V",""),"")

A1 = employee name
B18 = Jan. 5
V = vacation

I have a 12 month calendar for each employee and when I enter V8 =( 8 hours
vacation ) the employees name and hours vacation display on a master calendar

I want to create another calendar to display absents for WSIB – S&A - - ELA
but I am unable to get it to work. Any help would be appreciated
 
Top