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


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?


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