CELKO (12/25/2014)
Why not move the data from the spreadsheets you already have to a table? Where is the ISO week-date column?
Hi Joe,
I think that's what the op is trying to do. I think they used the spreadsheet as a working tool to make all of the dates they needed to load into a Fiscal Calendar Table and were trying to figure out the formula that they needed to calculate other columns like Fiscal Year and Fiscal Month, etc. Once done, the goal was to have all this info in a table.
As for the ISO week-date column, that would certainly be easy enough to add especially since there's actually a function for it but wouldn't that be superfluous considering that they're not actually following anything that has to do with ISO date parts?
While you're here... you've been around the block with a lot of companies and have played a role in the development of the ISO standards. I've never understood why companies and even the government have these odd-ball Fiscal Year "standards" like the Fiscal Year starting on the first Monday of April (for example). What is the purpose of doing such a thing instead of following either the good ol' Calendar Year or the ISO standard year? It seems like a huge headache for all and I just don't get it.
--Jeff Moden
Change is inevitable... Change for the better is not.