Av8tordude
Well-known Member
- Joined
- Oct 13, 2007
- Messages
- 1,074
- Office Version
- 2019
- Platform
- Windows
I'm seeking help with a formula that will can sum the Blue box values base on the current year.
Example: From Aug 31 - Dec 31 totals: 17065.79. The values after Dec 31 should not be included in the sum. The dates in the red boxes are dynamic and will adjust as the current month passes. Example Aug 31 will display Sep 30 when September arrives.
Example: From Aug 31 - Dec 31 totals: 17065.79. The values after Dec 31 should not be included in the sum. The dates in the red boxes are dynamic and will adjust as the current month passes. Example Aug 31 will display Sep 30 when September arrives.