Formula to Calculate the Representative Week (number) for each Date

Question

I need to calculate which date each week represents, I have a Weeks Attribute Module. I have tried some formulas but they did not work. I would really appreciate if someone could give me some advice or a direction.😊

Farangiz · Accepted Answer

seymatas1 Thank you for your response, but unfortunately I am not using weekly calendar.

derektslim · Accepted Answer

I would be assuming you had created a list that had the weeks and years in it, similar to the Weeks under time dimension.

You should be able to achieve the results with the following line items:

* ITEM » ITEM(Custom List)
* NAME ITEM » NAME(ITEM)
* Week No. » Formula to derive week number in Number format
* Year » Formula to derive year in Number format
* Date List » DATE(Year, 1, 1) + 'Week No.' * 7 in Date Format
* Date Start
* Date End

How my custom week list looks:

Formula behind it:

You can derive a start and end date, and then point your dates back to between this range to derive your custom week.

Hope it helps in the right direction!

Best regards,

Derek