Please help - looking for a formula that can calculate the days

[Joe]

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

[Mallycat]

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

[Nikki]

=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
>
>

[joeu2004@hotmail.com]

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.)

[Joe]

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