function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
YOANA PopovaYOANA Popova 

Report this ad 0 Good day, how to adjust this formula to be valid for all years, not only for specific one MOD(FLOOR(("Created Date" - DATEVALUE( "2016-01-01 " ) ) / 7 ), 52) + 1

Good day, 

I have to adjust the formula to be calculated for all previous years, not only for specific one. Do you have any idea how to modify this formula: 
MOD(FLOOR(("Created Date" - DATEVALUE( "2016-01-01 " ) ) / 7 ), 52) + 1
PriyaPriya (Salesforce Developers) 
Hi Yoana,

You have to provide more detail about your requirement.

Thanks!