How to auto-populate my company's fiscal year week number

Hello,


I am having a formula in the "number of chambers shipped" to add them from a different sheet.

the "date" column will auto-populate

I would like for the Week column to auto-populate my company's fiscal year. I have no idea how to do that. Can someone help me figure this out?


Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓

    Hi Diego,

    If your fiscal year starts on January 1st you can use =weeknumber(date@row)

    If your fiscal year is not January 1st you'll need a different formula. If your fiscal years starts on October 1st the formula would be:

    =ROUND(((Date@row - DATE(2021, 10, 1)) / 7) + 0.49, 0)

    Substitute the 1st day of your fiscal year for DATE(2021, 10, 1)

    Work for you?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Answers