Help! In the table below, I want it to automa...

(WhiteCrow MD) #1

Help! In the table below, I want it to automatically input the Duty Team based on a predetermined Calendar Schedule. I have made a separate table for the schedule with columns for Calendar Day, Duty Team, Clerks, Consultants

How to automatically input the Duty Team based on the calendar day? I imagine the algorithm to be Day(Today()) input the corresponding Duty Team or i make it a long one like this If calendar day = 1, 4, 7, 10, 13, 16, 19, 22, 25, 28, 31 then show “A” If calendar day = 2, 5, 8, 11, 14, 17, 20, 23, 26, 29 then show “B” If not then show “C”

(Aleksi Alkio) #2

How about…

IF(IN(DAY(TODAY()),{1,4,7,10,13,16,19,22,25,28,31}),“A”,IF(IN(DAY(TODAY()),{2,5,8,11,14,17,20,23,26,29}),“B”,“C”))