[Resolved] Counting weeks between two dates

[dreams4000]

Hey all,

Is there an easy way to count the number of weeks between two dates while still including the weeks that the dates are in with week ending on Sunday? eg..

Date 1 = 03-02-2004 (is a Wed.)
Date 2 = 03-22-2004 (is a Tues.)

This should give 4 weeks total as it would include the week where 03-02 is and the week 03-22 is as well as the two in between.

[Merve]

Yes, there is an easy way.
Something like this:

$weeks_between = abs(date("W", mktime(0, 0, 0, 3, 2, 2004)) - date("W", mktime(0, 0, 0, 3, 22, 2004))) + 1;

Hope this helps!
Merve

[dreams4000]

works great! thanks!

[dreams4000]

Not resolved now I guess.. humm

Why would the following give 46 as the weeks difference when it should really be 8 I think. Anytime the years change, it seems to mess things up.

$weeks_between = abs(date("W", mktime(0, 0, 0, 12, 2, 2005)) - date("W", mktime(0, 0, 0, 1, 22, 2006))) + 1;

It looks like it is counting between the month/weeks only and not taking into account that there is a year change and acting as though my starting date is jan 22 going to dec 2 which would give that number of weeks, but the problem is the starting date is dec 2 and ending date is jan 22 of the following year so it should only count up to that, not flip.:\

[Installer]

Try this:

function number_of_weeks($date_1, $date_2)
{
    $one_week = 7 * 24 * 60 * 60;
    $date_1 = strtotime($date_1);
    $date_2 = strtotime($date_2);
    $weeks = ceil(($date_2 - $date_1) / $one_week);
    $wk_day_1 = date('w', $date_1);
    $wk_day_2 = date('w', $date_2);
    if ($wk_day_1 == '0') {
        $wk_day_1 = '7';
    }
    if ($wk_day_2 == '0') {
        $wk_day_2 = '7';
    }
    if ($wk_day_2 <= $wk_day_1) {
        $weeks++;
    }
    return $weeks;
}

$date_1 = '03-02-2004';
$date_2 = '03-22-2004';
$date_1 = str_replace('-', '/', $date_1);
$date_2 = str_replace('-', '/', $date_2);
echo number_of_weeks($date_1, $date_2) . '<br />';
$date_1 = '12/02/2005';
$date_2 = '01/22/2006';
echo number_of_weeks($date_1, $date_2) . '<br />';

// Echos:
// 4
// 8

[dreams4000]

Works great! thanks! The other was giving some odd results between years, the new one seems to correct for that. Thanks much!