You need to sign in to do that
Don't have an account?
YOANA 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
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
Please find the useful formulas from below link.
https://help.salesforce.com/s/articleView?id=sf.formula_examples_dates.htm&type=5
Regards,
Shikhar