Thread: [Solved] Index/Matching Problem
View Single Post
 
Old 07-27-2016, 12:23 AM
c991257 c991257 is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Mar 2014
Location: Zambia
Posts: 61
c991257 is on a distinguished road
Default

Have added the option of specific days off with the value 2.

So for each shift the value 0, 1 or 2 is entered and the color of the cell changes accordingly.

For RDOs I have set it up so the value 2 should be entered for both shifts (entering only a single 2 will sum as a half RDO).

/Møller
Attached Files
File Type: xlsx Calendar Example 2.xlsx (37.4 KB, 10 views)
Reply With Quote