how to get the BEGIN_DATE and END_Date from week

[#1]

can anyone help me i am having year and week is there any way to get begin date of week and end date of week from it

[sushil353 · Accepted solution]

Hi,

Try This:

first of all make date from week no and year using:

makeweekdate(2013,11) returns 03/11/2013

then get the week start data and end date using:

=WeekStart(MakeWeekDate(2013,11)) returns 03/11/2013

=WeekEnd(MakeWeekDate(2013,11)) returns 03/17/2013

HTH

Sushil