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
=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