Forum Discussion

JulianTobon's avatar
JulianTobon
Helper I
9 years ago

Function To Calculate Fiscal Week

Hi all,   I want to calculate the number of weeks based on the date of sale, I used the formula:  week = WEEKNUM(Scorecard[SalesDate],2) This works very well but not for what I need, Due to work ...
Need Help
JulianTobon's avatar
JulianTobon
Helper I
9 years ago

Phil_Seamark excuseme, Your form is a little more successful, what I can detect in it is that it starts the count of the week on Sunday, but it should start on Monday. We have to indicate that in the Formula?

Hanuma's avatar
Hanuma
Regular Visitor
7 years ago

JulianTobon Hi ,

 Please share the solution if you have the solution for the fiscal week starts with monday

thanks