[xpost][/xpost] I am struggling with trying to get a formula that will help to do the followingwe have the date broken down into individual cells , D D = AN1 and AO1from AN1 to AU1In the table , an identifier is indicated from F9 to P9 /Q9 toAA9 and finally from AB9 to Al9We need to look at the first two digits of the DD ie AN1 and AO1, if the day is from the1st of the month to the 9th of the month, we ignore the D DI am struggling with trying to get a formula that will help to do the followingwe have the date broken down into individual cells , D D = AN1 and AO1from AN1 to AU1In the table , an identifier is indicated from F9 to P9 /Q9 toAA9 and finally from AB9 to Al9We need to look at the first two digits of the DD ie AN1 and AO1, if the day is from the1st of the month to the 9th of the month, we ignore the D DFrom the 10th day of the month to the end of the month, we will now sum the two digitd ie D+Dand if its greater than 9 , we mod it to a single digitsWe will get an answer, this answer we need to match , wth the identifier and then place in cellbelow the highlighted yellow cellfor example if N9 = 4 and the result from the calculation is 4, we paste the 4 into N10Likewise, we do the same for Y9 and Y10 and AJ9 and AJ 10From the 10th day of the month to the end of the month, we will now sum the two digitd ie D+Dand if its greater than 9 , we mod it to a single digitsWe will get an answer, this answer we need to match , wth the identifier and then place in cellbelow the highlighted yellow cellfor example if N9 = 4 and the result from the calculation is 4, we paste the 4 into N10Likewise, we do the same for Y9 and Y10 and AJ9 and AJ 10