Forum Discussion
sdg33139
Jul 16, 2024Copper Contributor
Rolling 365 Calculation Glitch
Hi I am trying to track days within certain countries for tax purposes using a rolling 365 calculation. I've followed tips from other posts but cannot get the formulas to work. Here are the ...
- Jul 22, 2024
HansVogelaar THANK YOU for your help.
HansVogelaar
Jul 16, 2024MVP
- sdg33139Jul 18, 2024Copper ContributorHi Hans
I greatly appreciate you taking the time to help.
Can it really be this easy for a Rolling 365 calculation? Or does this solution miss something that would be captured using SUMIF?
Thank you!
Seth- HansVogelaarJul 19, 2024MVP
The formula that I posted will work correctly if column A lists all dates once, without gaps.
- sdg33139Jul 22, 2024Copper Contributor
HansVogelaar THANK YOU for your help.