Thats an issue - I have hundreds of files/cells that uses the week num function so dont want to change in each individual file. Is there anyway in overriding the Weeknum function?
No you can't do it with WEEKNUM. You either have to use a formula like the one in my previous post or use VBA or download morefunc add-in and use the ISO.WEEKNUM function......
Sorry to bring this back to life - just a quickie.
The addin is great for single person use but I am having problems if there are multiple users using different PC's (not at the same time). The add in loads from my C Drive and when someone else loads it they have to delete out the filepath before their add in on their computer calculates it.
Is there anyway round this? Am currently having to Write Macro's for every file to manually populate the isoweeknum.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.