함수 weekdate2date()

1 개요

week date to date

• test set

2004-W53-6 → 2005-01-01

2004-W53-7 → 2005-01-02

2005-W52-6 → 2005-12-31

2007-W01-1 → 2007-01-01

2007-W52-7 → 2007-12-30

2008-W01-1 → 2007-12-31

2008-W01-2 → 2008-01-01

2009-W01-1 → 2008-12-29

2009-W01-3 → 2008-12-31

2009-W01-4 → 2009-01-01

2009-W53-4 → 2009-12-31

2009-W53-7 → 2010-01-03

2 Excel

=DATE(LEFT(A1,4),1,1)-WEEKDAY(DATE(LEFT(A1,4),1,1)-1)+7*(MID(A1,7,2)-INT((8-WEEKDAY(DATE(LEFT(A1,4),1,1),2))/4))+RIGHT(A1,1)

3 PHP

$weekdate = '2009-W01-3';
$date = date("Y-m-d", strtotime($weekdate));
echo $date;

function weekdate2date($weekdate) {
  return date("Y-m-d", strtotime($weekdate));
}

4 같이 보기

• 함수 week2date
• this week
• date2weekdate
• ordinaldate2date