Sum for a specific year
Hello again my friends,
I have a portal that represents the number of days taken throughout employment, so it spans several years. My goal is to sum the sick days of just the current year excluding any previous years count. The attached is the current calculation im using... problem is that it either looks at one one records date instead of all of them and the calculation fails or it sums everything instead of the specific date. Thanks in advance for any help.