Makes sense. Thanks. We use the fiscal year instead of calendar year, so I'll have to adapt the formula a little bit. One thing I have come across while trying to do that is that last year's fiscal year started on July 1, 2006, which was two years ago when using the YEAR() function - since we're now in 2008.
That's why I was hoping I could use the FISCALSTART() function, but I have been unable to find where to specify the beginning of the fiscal year.