Calculate Months From two dates

Question

I need to calculate months from two dates

For example :

If date1 = '2014-08-20' means 20th Aug 2014

& date2 = '2014-09-17' means today date

then I need to difference of months = 2 (Aug + September)

Same way

     If `date1 = '2014-03-15'` means 15th March 2014

     &  `date2 =  '2014-09-17'`  means today date

then I need to difference of months = 7 (March + April + May + June + July + Aug + SEPT)

How can I do with php date functions ?

Please check, may be duplicate :- http://stackoverflow.com/questions/13416894/calculate-the-number-of-months-between-two-dates-in-php — Khushboo, Sep 17 '14 at 06:32
possible duplicate of [How to calculate the difference between two dates using PHP?](http://stackoverflow.com/questions/676824/how-to-calculate-the-difference-between-two-dates-using-php) — Clément Malet, Sep 17 '14 at 06:32

score 2 · Answer 1 · answered Sep 17 '14 at 06:33

2

$date1 = new DateTime('2014-08-20');
$date2 = new DateTime('2014-09-17');

$diff = $date2->diff($date1);

$diff->format('%m months');

answered Sep 17 '14 at 06:33

Sadikhasan

18,365
21
80
122

it gives me 0 months; But I need as I said in question is months = 2 – Sandip Patel Sep 17 '14 at 06:37

score 2 · Answer 2 · answered Sep 17 '14 at 06:46

2

If you want to take into account for each months passed, you could try this:

$date1 = new DateTime('2014-03-15');
$date2 = new DateTime();
$date2->modify('last day of this month'); // adjust it to take into account
$int = new DateInterval('P1M'); // every month
$count = 0;
$range = new DatePeriod($date1, $int, $date2);
foreach($range as $d) {
    ++$count; // for each month incremenent
}
echo $count;

answered Sep 17 '14 at 06:46

Kevin

41,694
12
53
70

yes Casimir et Hippolyte has given very short answer so It will helpful to me & others also.Thanks to you again for your answer. – Sandip Patel Sep 17 '14 at 06:58
sure @SandipPatel glad i was able to help – Kevin Sep 17 '14 at 06:59

score 2 · Accepted Answer · answered Sep 17 '14 at 06:50

2

This is what you are looking for?

$date1 = new DateTime('2014-08-20');
$date2 = new DateTime('2014-09-17');

echo  $date2->format('n') - $date1->format('n') + 1;

answered Sep 17 '14 at 06:50

Casimir et Hippolyte

88,009
5
94
125

score 0 · Answer 4 · edited May 23 '17 at 12:12

0

You can do with:

$first_date = '2014-03-15';
$second_date = '2014-09-17';

$date1 = strtotime($first_date);
$date2 = strtotime($second_date);

$year1 = date('Y', $date1);
$year2 = date('Y', $date2);

$month1 = date('m', $date1);
$month2 = date('m', $date2);

$diff = (($year2 - $year1) * 12) + ($month2 - $month1);

But to count day difference also, we can do as follow:

$date_interval = $first_date->diff($second_date);
        echo "difference " . $date_interval->y . " years, " . $date_interval->m." months, ".$date_interval->d." days ";

Check this link link

edited May 23 '17 at 12:12

Community

1
1

answered Sep 17 '14 at 06:38

Mobasher Fasihy

1,021
2
9
17

it gives me 6 months; But I need as I said in question is months = 7 – Sandip Patel Sep 17 '14 at 06:40
so for that it should also count the day difference? yeah. – Mobasher Fasihy Sep 17 '14 at 06:55

score 0 · Answer 5 · edited May 23 '17 at 10:26

You can Do it in the following manner.

Consider this Example :

<?php
$start    = new DateTime('2011-12-02');
$start->modify('first day of this month');
$end      = new DateTime('2012-05-06');
$end->modify('first day of next month');
$interval = DateInterval::createFromDateString('1 month');
$period   = new DatePeriod($start, $interval, $end);

foreach ($period as $dt) {
    $monthNum=$dt->format("m");
    echo $dt->format("Y").date('F', mktime(0, 0, 0, $monthNum, 10)). PHP_EOL;
}

See in action Here

Reference : How to list all months between two dates

Calculate Months From two dates

5 Answers5