I've searched but can't find an answer to my issue. I am trying to create a tool where managers can call Mandatory overtime by simply choosing MOT from a drop down menu. When they do I want another cell to fill automatically with a date.
For example, our A shift employees work Sun.-Weds 10 hrs a day. When MOT is called they will work on Thursday. What I want is for the manager to choose MOT for A-Shift and another cell will automatically fill with the date for the next upcoming Thursday.
I would appreciate any help. If you need more info. please let me know.