@Melisa, If my Financial year starts at 1 Nov instead of 1 Jan, the above code will not work as it starts the week number from Jan instead of Nov. It works fine for the remaining quarters. How could I modify the code to get this to work?
@Melisa, thank you so much. I am trying to get through all the study material but it is a slow process and I haven’t got to dates yet. In the interim, you have helped me so much to solve my problem for work.
@Melisa, Could I trouble you for one more favour? I am trying to create a column without success for Fiscal Year and Mth as YYYYMM format - Nov 2020 would be 202001.
I have sat here for the last hour trying to work it out