counting no. Of days categorized in months

Question

counting no. Of days between two dates inclusive of starting date is easy but how to count them saperately for each months like between 1.1.2014 and 15.5.2014

Jan 31
Feb 28
Mar 31
Apr 30
May 15

@Dagon the second answer of that question is more relevant to this question that the accepted answer — scrowler, May 20 '14 at 22:23

nl-x · Accepted Answer · 2014-05-21T00:06:09.540

I think you are looking for something like this:

$start = new DateTime('2014-01-01');
$end = new DateTime('2014-05-15');

$tmpStart = $start;
while ( $tmpStart <= $end ) {
    $tmpEnd = clone $tmpStart;
    $tmpEnd = $tmpEnd->modify('last day of this month');
    $tmpEnd = $tmpEnd < $end ? $tmpEnd : clone $end;
    echo $tmpStart->format("M") . " " . ($tmpEnd->diff($tmpStart)->format("%a")+1) . "\n";
    $tmpStart = $tmpEnd->modify('first day of next month');
}

This outputs:

Jan 31 
Feb 28 
Mar 31 
Apr 30 
May 15

score 0 · Answer 2 · answered May 20 '14 at 22:29

0

get the number of days in month from cal_days_in_month() function and use date_diff() to compare between those

answered May 20 '14 at 22:29

Karl Adler

15,780
10
70
88

score 0 · Answer 3 · answered May 20 '14 at 22:37

If I understand correctly, you want to find the difference in days between two dates?

<?php
$startDate = mktime(0, 0, 0, 1, 1, 1970); //Enter your start date and time
$endDate = mktime(0, 0, 0, 5, 20, 2014); //Enter your end date and time

echo ($endDate-$startDate)/60/60/24; //This works out the number of days between the two
?>

Outputs:

Look at the mktime() documentation to understand how to input your date into the mktime() function.

counting no. Of days categorized in months

3 Answers3