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
hogehogehogehoge 

Help me! This Code

F(DAY( CloseDate ) / 7 <= 1 , 1 , 
IF(DAY( CloseDate ) / 7 <= 2 , 2 , 
IF(DAY( CloseDate ) / 7 <= 3 , 3 , 
IF(DAY( CloseDate ) / 7 <= 4 , 4 , 
IF(DAY( CloseDate ) / 7 <= 5 , 5 , 0) ))))
It seems that you are counting the weeks of the month.
 
Sai PraveenSai Praveen (Salesforce Developers) 
Hi,

Are you getting any syntax error?

Thanks,
 
hogehogehogehoge
No, there are no errors. But I would like to know what this formula represents.
I want to know what kind of process
Sai PraveenSai Praveen (Salesforce Developers) 
Hi,

The formula seems to calculte which week does the date falls in the month.

Let me know if you face any issues.

If this solution helps, Please mark it as best answer.

Thanks,