sakrams
Board Regular
- Joined
- Sep 28, 2009
- Messages
- 59
- Office Version
- 2016
- Platform
- Windows
Greetings Excel Gurus,
Wondering if you could help me with a formula to achieve this automatically. I am trying to generate a employee schedule and want to achieve the below.
I
If Employee 1 Schedule start is Sun, then lookup the day from row 2 and enter "D" if (Sun, Mon, Tue, Wed) and "X" if (Thu, Fri, Sat)
If Employee 2 Schedule start is Sat, then lookup the day from row 2 and enter "D" if (Sat, Sun, Mon, Tue) and "X" if (Wed, Thu, Fri)
If Employee 3 Schedule start is Mon, then lookup the day from row 2 and enter "D" if (Mon, Tue, Wed, Thu) and "X" if (Fri, Sat, Sun)
Wondering if you could help me with a formula to achieve this automatically. I am trying to generate a employee schedule and want to achieve the below.
I
If Employee 1 Schedule start is Sun, then lookup the day from row 2 and enter "D" if (Sun, Mon, Tue, Wed) and "X" if (Thu, Fri, Sat)
If Employee 2 Schedule start is Sat, then lookup the day from row 2 and enter "D" if (Sat, Sun, Mon, Tue) and "X" if (Wed, Thu, Fri)
If Employee 3 Schedule start is Mon, then lookup the day from row 2 and enter "D" if (Mon, Tue, Wed, Thu) and "X" if (Fri, Sat, Sun)