Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
ShowAll Questionssorted byDate Posted
sarvesh001

# 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

Tejpal 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))`

Tejpal 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))`

This was selected as the best answer
sarvesh001

Hi Tejpal Kumawat,

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

sarvesh001

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,