To calculate Coming two weeks

[sat_tok52]

Hi Guru's,

I want to calculate coming two weeks data, it means today is 48 week ,As per my requirement to calculate 49,50 week separately ,Any help two write the expression.I tried week(Today())+1 and week(Today())+2 it's not  working any help that would be appreciate.

Thanks,

Sateesh.T

[MK_QSL]

Sateesh, when you said coming two weeks data.. but what data?

Next Two Week Start and End can be calculated as below.

=WeekStart(Today()+7)

=WeekEnd(Today()+7)

=WeekStart(Today()+14)

=WeekEnd(Today()+14)

[tresesco · Accepted solution]

Sateesh T wrote:

..I tried week(Today())+1 and week(Today())+2 it won't work

Can you please tell what won't work? Because, I guess they would return 49/50 correctly. Please explain your case in more detail.