Browse by categories
-
All
-
Collaboration
-
Configuration & Data Management
-
CPQ and Billing
-
Customer Service & Support
-
Desktop Integration
-
Einstein Analytics
-
Email
-
Email Marketing
-
Journey Management
-
Mobile
-
Mobile Messaging
-
Packaging, Uploading & Installing Apps
-
Reports & Dashboards
-
Sales & Marketing
-
Security
-
Social Marketing
-
Trailhead Challenges
-
Additional Products

How to get Reporting Week as a number between 1-52
I'm trying to make a formula that tells me the Reporting Week by a date field (in this case, it's a field called Requested Date - which is the date an individual requested a service).
I've looked at so many formulas online and some work except for the end of the year the weeks are -1. I can't seem to find the 1 true formula for determining this. Here is the formula I am currently using.
MOD( FLOOR((DATEVALUE(Requested_Date__c) - DATE(1900,01,01))/7),52)-1I've tried using -1 and +1 at the end of the formula and neither have worked. Any suggestions? This would be a huge help to everyone I think if we figured this out!
All Answers