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
sarvesh001sarvesh001 

How to get week number of a month from closedate

Hi, 
I want to get the week number of a month from close date like week-1,week-2,week-3,week-4 in  a formula field.\

can any one help out for this .

Thanks,
Sarvesh

 
Best Answer chosen by sarvesh001
Tejpal KumawatTejpal Kumawat
Hello Sarvesh,

Use this formula :
  
IF(MOD(DAY(Birthdate), 7) = 0, "Week-"& TEXT(ROUND(DAY(Birthdate)/ 7, 0)) , "Week-"& TEXT(ROUND(DAY(Birthdate)/ 7, 0)+1))

If this answers your question mark Best Answer it as solution and then hit Like!

All Answers

Tejpal KumawatTejpal Kumawat
Hello Sarvesh,

Use this formula :
  
IF(MOD(DAY(Birthdate), 7) = 0, "Week-"& TEXT(ROUND(DAY(Birthdate)/ 7, 0)) , "Week-"& TEXT(ROUND(DAY(Birthdate)/ 7, 0)+1))

If this answers your question mark Best Answer it as solution and then hit Like!
This was selected as the best answer
sarvesh001sarvesh001

Hi Tejpal Kumawat,

Thank you so much it working fine.............
 
sarvesh001sarvesh001

Hi Tejpal Kumawat,

It working fine but i want for every month  from 1st onwards should take week-1.

Now it is taking in another manner.

Please could you help me out.

Thanks,