If / substitute for employee calendar

[grizz]

I use this formula which when I enter D8 in an employee calendar the master calendar will display employee,s name and D 8 for days ---- is there a way to add a N so if he is on nights it will display N ---they could be on days or nights

=IF(LEFT(UPPER('[John Doe''s Calendar..xls]2011'!C61),1)="D",'[John Doe''s Calendar..xls]2011'!A1&" "&SUBSTITUTE(UPPER('[John Doe''s Calendar..xls]2011'!C61),"D",""),"")

 

[Robert Mika]

Maybe like this:
=IF(LEFT(UPPER('[John Doe''s Calendar..xls]2011'!C61),1)="D",'[John Doe''s Calendar..xls]2011'!A1&" "&SUBSTITUTE(UPPER('[John Doe''s Calendar..xls]2011'!C61),"D",""),IF(LEFT(UPPER('[John Doe''s Calendar..xls]2011'!C61),1)="N",'[John Doe''s Calendar..xls]2011'!A1&" "&SUBSTITUTE(UPPER('[John Doe''s Calendar..xls]2011'!C61),"N",""),""))

 

[grizz]

sorry for the delayed response but Thanks Mika it works excellent