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โ
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โ))
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |