Skip Ribbon Commands
Skip to main content

Erin Glenn's Blog

:

Erin Glenn's Blog > Posts > Calculating Week Number in Calculated Field
February 28
Calculating Week Number in Calculated Field

I needed to calculated the week number based off the Created date.  

I found many blog and forum posts using the formula below, but it kept adding 5 weeks.  I think it had something do to with my regional settings ("Define Your Work Week")

=INT((Created-DATE(​YEAR(Created),1,1)+(TEXT(WEEKDAY(DATE(YEAR(Created),1,1)),"d")))/7)+1​

I did find this formula that worked!

​=INT((Created-DATE(YEAR(Created-WEEKDAY(Created-1)+4),1,3)+WEEKDAY(DATE(YEAR(Created-WEEKDAY(Created-1)+4),1,3))+5)/7)​

Comments

There are no comments for this post.