Calculating days of week given a week number

by

PHP

$week_number = 40;
$year = 2008;
for($day=1; $day<=7; $day++)
{
    echo date('m/d/Y', strtotime($year."W".$week_number.$day))."\n";
}

Below post was because I was an idiot who didn’t read the question properly, but will get the dates in a week starting from Monday, given the date, not the week number..

In PHP, adapted from this post on the PHP date manual page:

function week_from_monday($date) {
    // Assuming $date is in format DD-MM-YYYY
    list($day, $month, $year) = explode("-", $_REQUEST["date"]);

    // Get the weekday of the given date
    $wkday = date('l',mktime('0','0','0', $month, $day, $year));

    switch($wkday) {
        case 'Monday': $numDaysToMon = 0; break;
        case 'Tuesday': $numDaysToMon = 1; break;
        case 'Wednesday': $numDaysToMon = 2; break;
        case 'Thursday': $numDaysToMon = 3; break;
        case 'Friday': $numDaysToMon = 4; break;
        case 'Saturday': $numDaysToMon = 5; break;
        case 'Sunday': $numDaysToMon = 6; break;   
    }

    // Timestamp of the monday for that week
    $monday = mktime('0','0','0', $month, $day-$numDaysToMon, $year);

    $seconds_in_a_day = 86400;

    // Get date for 7 days from Monday (inclusive)
    for($i=0; $i<7; $i++)
    {
        $dates[$i] = date('Y-m-d',$monday+($seconds_in_a_day*$i));
    }

    return $dates;
}

Output from week_from_monday('07-10-2008') gives:

Array
(
    [0] => 2008-10-06
    [1] => 2008-10-07
    [2] => 2008-10-08
    [3] => 2008-10-09
    [4] => 2008-10-10
    [5] => 2008-10-11
    [6] => 2008-10-12
)

More Related Contents:

  1. Php date() Date and time is stuck [closed]
  2. Days remaining before birthday in php [duplicate]
  3. How to get time difference in minutes in PHP
  4. How can I compare two dates in PHP?
  5. Add number of days to a date
  6. PHP DateTime::modify adding and subtracting months
  7. PHP mysql insert date format
  8. Accessing dates in PHP beyond 2038
  9. Date Difference in php on days? [duplicate]
  10. How to list all months between two dates
  11. Difference between 2 dates in seconds [duplicate]
  12. PHP convert date format dd/mm/yyyy => yyyy-mm-dd [duplicate]
  13. How can I check if the current date/time is past a set date/time?
  14. Day difference without weekends
  15. How to generate random date between two dates using php?
  16. How to count days between two dates in PHP?
  17. Print time in 15-minute increments between two times in the same day
  18. How to reformat date in PHP?
  19. Check for consecutive dates within a set and return as range
  20. Set timezone in PHP and MySQL
  21. PHP date() in foreign languages – e.g. Mar 25 Aoû 09 [duplicate]
  22. Adding three months to a date in PHP
  23. PHP date returning wrong Month on subtracting one month
  24. Get date range between two dates excluding weekends
  25. mysql – INSERT date range into date columns IF dates don’t overlap with existing ones
  26. PHP day of week numeric to day of week text
  27. adding 1 day to a DATETIME format value
  28. day of the week to day number (Monday = 1, Tuesday = 2)
  29. php weeks between 2 dates
  30. PHP: Date larger than current date

Leave a Comment