Sign Up ›
  • Cardona
  • NEWBIE
  • 25 Points
  • Member since 2013
  • Chatter
    Feed
  • 1
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 2
    Replies
SOLVED
4 replies

How to calculate week number in a 53 week year

Hello,

 

I am trying to gather the week number of a week within a fiscal year. I have been able to calculate this for the standard 52-week year using the following formula:

 

MOD(FLOOR( ( CloseDate -DATEVALUE("YYYY-MM-DD"))/7),52)+1

 

My issue is that i need to now calculate the fiscal week for a fiscal year that has 53 weeks. 

 

Thanks for the help.

SOLVED
4 replies

How to calculate week number in a 53 week year

Hello,

 

I am trying to gather the week number of a week within a fiscal year. I have been able to calculate this for the standard 52-week year using the following formula:

 

MOD(FLOOR( ( CloseDate -DATEVALUE("YYYY-MM-DD"))/7),52)+1

 

My issue is that i need to now calculate the fiscal week for a fiscal year that has 53 weeks. 

 

Thanks for the help.