I use the below code for my absence tracker which was kindly provided on here.
I now need to change it, so instead of looking at current 12 month rolling period and previous 12 month rolling period, it looks at:
Current 6 months Tab - All absence in the last 6 month rolling period from...
I am attempting to write an if statement that will read the contents of a cell, and based on this act appropriately.
Is this possible? It only needs to look for two conditions, so as follows:
If cell C4 Contains the word "evening" (
D5 = 5 + 2
Else If cell C4 Contains...