Assistance with a calculation that compares the current date to month/year
I am calculating labor costs based on project duration. I need to know the labor dollars only for the months greater than the current month (for example, if this month is July/2020, then only calculate August/2020 through February/2021. The following formula sums hours x rate based on value in month columns 1 - xx. What I have below works for the month of July/2020, but it is producing a negative number because I am subtracting the value of a calculated column [Total Labor Forecast]25 at the end. I have tried to move [Total Labor Forecast]25 immediately following SUM, but it doesn't work. I'm sure this is a syntax issue, but I have not been successful in resolving it. Any assistance or guidance is greatly appreciated! Thank you.
=IF(AND(MONTH(TODAY()) = 7, YEAR(TODAY()) = 2020), SUM([Month 1]25 * [Month 1]2) * Rate25) - [Total Labor Forecast]25
Help Article Resources
Check out the Formula Handbook template!