I am trying to find out if there is a way to perform the following task
using a formula:

(A) (B) (C)
Start date Completion date amount of days it is taking to
complete
06/13/06 06/15/06 2 days

I am not sure if this is possible but any assistance offered is truly
appreciated.

Regards,
Joe

I assume you want to calculate the number of days between the 2 dates

Just subtract one from the other =B1-A1 and make sure the cell
containing the formula is formatted as General.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=553844

=NETWORKDAYS(B15,C15)
b15=start
c15=end date
this will give you 3 days because assumes working on 13, 14 & 15 but if you
still need 2 days you can subtract by 1,
=NETWORKDAYS(B15,C15)-1

"Mallycat" wrote:


I assume you want to calculate the number of days between the 2 dates

Just subtract one from the other =B1-A1 and make sure the cell
containing the formula is formatted as General.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=553844

Joe wrote:
I am trying to find out if there is a way to perform the following task
using a formula:
(A) (B) (C)
Start date Completion date amount of days it is taking to
complete
06/13/06 06/15/06 2 days
I am not sure if this is possible but any assistance offered is truly
appreciated.

If the dates are in A3 and B3 respectively, did you try putting the
following in C3 (where you want 2):

=B3-A3

Note: You might need to explicitly set the format to Number with 0
decimal places (Format Cells).

If that does not work, I wonder if it is because you Date Language
format is not English.

By the way, in my book, if the start date is 6/13 and the end date is
6/15, the task took __3__ days. That formula would be:

=B3-A3+1

Arguably, it depends on the time of day for starting and ending. But
if you start on 6/13 and end on 6/13, wouldn't you say it took __1__
day, not zero days?

(I would, unless it took me less than 4 hours. Even then, I would
state a fraction of a day, not zero.)

Thank you Matt. That was painless. :-)


Mallycat wrote:
I assume you want to calculate the number of days between the 2 dates

Just subtract one from the other =B1-A1 and make sure the cell
containing the formula is formatted as General.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=553844