weekstart function

[#1]

Hello Community,

i have one question.

I have a date dimension. I want with the weekstart function that the next monday after 2 weeks should be shown.

So for example

2012-09-03 => 2012-09-17,

2012-09-06 => 2012-09-04,

2012-09-14 => 2012-10-01

I attached the file. Can anyone please help me??

Best regards,

Aylin

[#2 · Accepted solution]

Hi Aylin,

this can be done with the following:

=WeekStart(Date_Dimension+20,0,0)

regards

[#3]

Thanks - it works!