•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Is there any way to convert a WEEKNUM for the tax year?
By default, the WEEKNUM formula starts the count in the first week of Jan, but most of the things I work on use the April to March tax year, not Jan to Dec calendar year. Is there anyway to change this, or do I have to create a formula in another cell to convert one to the other, perhaps by adding/subtracting the additional number of weeks between Jan and Apr?
[link] [comments]
Want to read more?
Check out the full article on the original site