I am going mad. I am using the following formulae to give the year and ISOWEEKNum
This works great with the exception of end of year when the year is wrong ie if I used the date as 30/12/2013 it would give me 2013 01 rather than 2014 01. Is there a formulae I can use for certain dates to return the correct year, or will I have to create a custom function to account for these?
Any help appreciated