I think I'd like a calculation that automatically figures out the FY of each donation, in perpetuity, as it were. FY runs 8/1 - 7/31.
Year ( date ) - ( Month ( date ) < 8 )
Thanks all! David, I wish I'd started from your starting point rather than where I did start! Comment, you solved the hard part - what actually works is:
If (Month (Donation_Date) ≥ 8; Year ( Donation_Date ) + 1; Year (Donation_Date))
Well, you didn't say that August 2009 is already FY 2010... in that case, I would make it:
Year ( date ) + ( Month ( date ) ≥ 8 )
which is the same thing you're doing, except shorter.
Thanks, Comment. I appreciate the more elegant solution.