2 Replies Latest reply: Apr 3, 2014 1:21 PM by Nicole Smith RSS

    Week() Function

    Ciarán McGowan



      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.