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

J

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
 
M

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 cel
containing the formula is formatted as General.

Mat
 
N

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
 
J

joeu2004

Joe said:
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.
Click to expand...

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