Sign Up ›
  • Gulbarga
  • NEWBIE
  • 0 Points
  • Member since 2013
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    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.

3 replies

Using Multiple Picklist Selecting Multiple Colours

IMAGE( CASE( Select_Multiple_Color__c ,
"Ash", "/resource/1362722614000/Ash",
"Black", "/resource/1362722679000/Black",
"Blue","/resource/1362722424000/Blue",
"Brown","/resource/1362722932000/Brown",
"Green","/resource/1362722445000/Green",
"Grey","/resource/1362722714000/Grey",
"Orange","/resource/1362722639000/Orange",
"Pink","/resource/1362722482000/Pink",
"Red","/resource/1362722574000/Red",
"Violet","/resource/1362722905000/Violet",
"Yellow","/resource/1362722509000/Yellow") ,"ColorImages")