Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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