There are 3 shifts, Every shift needs change duty after a Week (Sunday) of the month through 24:00 hrs. as given below detail.

Date: Friday,01/12/2017
Shift:A 00:00 TO 08:00 hrs (Night-duty)
Shift:B 08:00 TO 16:00 hrs (Morning-duty)
Shift:C 16:00 TO 24:00 hrs (Evening-duty)

Date: Saturday,02/12/2017
Shift:A 00:00 TO 08:00 hrs (Night-duty)
Shift:B 08:00 TO 16:00 hrs (Morning-duty)
Shift:C 16:00 TO 24:00 hrs (Evening-duty)

Date: Sunday,03/12/2017
Shift:A 00:00 TO 08:00 hrs (Night-duty)
Shift:B 08:00 TO 16:00 hrs (Morning-duty)
Shift:C 16:00 TO 24:00 hrs (Evening-duty)

Date: Monday,04/12/2017 (Duty Shift would be Changed)
Shift:A 16:00 TO 24:00 hrs (Evening-duty)
Shift:B 00:00 TO 08:00 hrs (Night-duty)
Shift:C 08:00 TO 16:00 hrs (Morning-duty)

Please help me that how to set formula in excel that will show me Shifts: A, B or C will perform their duties on given date in 24:00 hrs.

May kindly please be helped me in this case. in advance I shall be very thankful for him/her.


Thanks & Regards:
Nadeem Sarwar