Ad:

PHP Discussion Thread
Unsolved
Views: 6233

Dec 4th, 2007

Calculate working days between dates

Expand Post »

Hi,

I need to calculate the number of working days between 2 dates entered in a page using PHP. The dates and the calculated number then need to be put into a MySQL database.

I am new to PHP, but understand the linking to the database and basic fnctions within PHP. Unfortunately I'm struggling with the calculation of the working days between dates.

Any help will be appreciated!
Thank You!

Steve

Similar Threads

Please Help! in Visual Basic 4 / 5 / 6
Difference between 2 dates by month in MS Access and FileMaker Pro

gooky9

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Dec 2007

Permalink

Dec 4th, 2007

Re: Calculate working days between dates

php Syntax (Toggle Plain Text)
<?php
$date1="2007-11-04";  //date 1 smaller than the 2nd date
$date2="2007-12-06";
$difference= (strtotime($date2) - strtotime($date1))/(24*60*60);
print $difference;
?>
<?php
$date1="2007-11-04";  //date 1 smaller than the 2nd date
$date2="2007-12-06";
$difference= (strtotime($date2) - strtotime($date1))/(24*60*60);
print $difference;
?>

Hope it helps.

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

Dec 6th, 2007

Re: Calculate working days between dates

so i guess you need to calculate days (mon-friday)
and to exclude sat & sun
is that it?

w_3rabi

Reputation Points: 18

Solved Threads: 9

Junior Poster

Offline

160 posts
since Dec 2006

Permalink

Dec 11th, 2007

Re: Calculate working days between dates

Yes! The code above calculates the days between the dates but i only need to count between Monday and Friday!!! Any help will be great, thanks!!!!

gooky9

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Dec 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Grab Mp3 Files and Play online

Next Thread in PHP Forum Timeline: Displaying teaser when rolling over link.

DaniWeb Message

Cancel Changes

User Name
Password