•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
Tagged with
#AI formula generation techniques
#formula generator
#rows.com
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#generative AI for data analysis
#tax year
#WEEKNUM
#convert
#April to March
#formula
#additional number of weeks
#calendar year
#change
#subtracting
#adding
#count
#start