WEEKNUM- Converting a date week into week, month, and financial year

  • Hi All

    I’m trying to track the number of reports my team reviews so I can report against performance through the year. I’ve tried to use the WEEKNUM formula for the first column with no joy.

    I’m need to populate the cells in yellow based on the [Date sent Back column] as the input data.


    [ATTACH=JSON]{"data-align":"none","data-size":"full","title":"Problem image 2.jpg","data-attachmentid":1206347}[/ATTACH]

    Any help will be greatly appreciated.

    Thanks
    Libby

  • Change the 2nd argument depending on when your week begins, but would be something like


    =WEEKNUM(E2, 1)


    Other formulas:
    =MONTH(E2)
    =INT((MONTH(E2)-1)/3)+1
    =YEAR(E2)

    Best Regards,
    Luke M
    =======
    "A little knowledge is a dangerous thing."

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!