Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
renjithpl
Specialist
Specialist

2018 week number issue

Hi 

I have written a basic script for Week, =Week(today() - 17), which returns 53, however, 2018 has only week 52. 

Any suggestion. 

Regards

Renjith

1 Solution

Accepted Solutions
vvira1316
Specialist II
Specialist II

There were 52 Sundays and 53 Mondays in 2018, Depending on the start day of the week you may get 52 or 53.

you may want to define/use default start day of the week

View solution in original post

1 Reply
vvira1316
Specialist II
Specialist II

There were 52 Sundays and 53 Mondays in 2018, Depending on the start day of the week you may get 52 or 53.

you may want to define/use default start day of the week