Forum Discussion
Attendance Calendar
I have added some dummy working days to the List of Employees sheet, and created a new rule for the Calendar View sheet.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Hi
Please let me know if this link workshttps://iehubltd-my.sharepoint.com/:x:/g/personal/jill_iehub_org/EfJAcpEcuSdDqlA06kX4OAMBIMrVpoLRLW_PXOfdC7eOXw?e=uc0my6 this is the original downloaded sheet without any of my team's details in.
As you will see in conditional formatting, Sat/Sun are greyed out, I would like to do the same with other days but only if a team member who does not work Wed and Thurs is chosen from the drop-down where it says Select Employee. I have a selection of full-time and part-time team members.
Thanks
Jill
Thanks, but where does it specify the days of the week a particular employee does not work?
HansVogelaar Hi Hans, thanks for producing the excel document that reflects part time workers.
However on the calendar view page, it still says 260 working days for the employee, even though they may only work 130 days.
Is it possible to change this to reflect the number of days they work?
Regards Ruth
See the attached version.
Hi
As this is the downloaded version, there isn't one, I presume I would have to add that information to the List of Employee tab with days worked against each employee name. Once I had done that, I wasn't sure if I had to use if or match formula.
Jill
I have added some dummy working days to the List of Employees sheet, and created a new rule for the Calendar View sheet.
