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 

Adjustment of formula field for converting date to week

Good day,

how can I 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
Shikhar .Shikhar .
Hi,

Please find the useful formulas from below link.

https://help.salesforce.com/s/articleView?id=sf.formula_examples_dates.htm&type=5

Regards,
Shikhar