"Thanks, Joe. I'm not an Excel wizard, but I think I can follow what you're doing. My customers have history going back 7+ years - I guess I would have to have a reference page for all possible periods, including future ones.…"
"I have a control sheet that has 3 parts: Current period and year, Date table, and format area. The current period and year is NOT the one for accounting system but for the reports. The date table has all 12 or 13 periods listed with columns for some…"
"Sorry, I just noticed my pasted picture didn't work in the comment above. The error is:
[Microsoft][ODBC SQL Server Driver][SQL Server] Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=,…"
"Thanks, DougW. Interesting, but it only works for calendar year fiscal years, and only for the current month. Most of my customers have non-calendar fiscal years, like October to September, for instance, and they always need to report on…"