Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 12-28-2015, 03:42 PM
Tiauna21 Tiauna21 is offline Creating Shifts/Weekends 24/7 Employees Windows XP Creating Shifts/Weekends 24/7 Employees Office 2013
Creating Shifts/Weekends 24/7 Employees
Join Date: Dec 2015
Posts: 1
Tiauna21 is on a distinguished road
Cool Creating Shifts/Weekends 24/7 Employees


I am using Excel 2013's Employee Attendance Tracker template, however we are a 24/7 business and not everyone's days off are the same. I want to be able to select an employee and have the calendar change to their exact days off. Right now there is a drop down menu to the right that says "Select an Employee" which changes the calendar to that persons attendance history. Also, it says my calendar is an Array and will not let me alter it. How do I change that? I would like to be able to mark S (sick) or T (tardy) on the dates, and have it calculate at the bottom. I attached the file that I am working with. I am not good with formula's, I would really appreciate the assistance!
Attached Files
File Type: xlsx Employee attendance tracker1.xlsx (36.2 KB, 12 views)
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating Shifts/Weekends 24/7 Employees reoccurring appointment that skips weekends dovaka Outlook 1 04-10-2015 01:58 AM
set daily goal for actual workdays, excluding weekends holidays and days off Brian Reilly Excel 1 01-24-2014 11:56 PM
Creating Shifts/Weekends 24/7 Employees Resources, subcontractors not employees Gene2720 Project 3 06-11-2013 04:48 AM
Creating Shifts/Weekends 24/7 Employees Recurring tasks falling on weekends - programme for working day prior guyc Project 3 09-26-2010 03:32 PM
IF statements that shifts to right. kent Excel 0 01-19-2006 02:23 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 08:12 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd. is not affiliated with Microsoft