This content has been marked as final. Show 2 replies
Is there any way to change the week() function so that my week #1 occurs on a set date each year instead of January 1st?
I have a series of files where week 1 should equal the first date in the excel file and the last week should equal the last date in the file. Each file only contains 6 months worth of dates so there should only be 26 weeks per year (ignoring weeks 27-52/53). The start dates vary slightly but usually occur around mid November each year and end in mid April.