Adding Multiple Dates to Get Total Days 1

[5656]

I'm running into a problem here and would appreciate any help.
I have 3 columns -- a date will be entered into each, in chronological order (in date format). The fourth column will be a "Total Days" column where I would like to compute the total number of days included from the first date (first column) to the third date (third column). Any suggestions ?

Thanks !!

 

[Databaseguy]

Excel ??? If so, in the 4th column: =c3-c1. Of course, this doesn't account for working days only....

Access?? In a query, add a new field: expr1: = [field end]-[field start]. Again, calander days only.... Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

 

[5656]

Thank you.
It is Excel...I feel a bit foolish...didn't realize it's that simple.
Thanks again !

 

[5656]

ok, one more question concerning the above...
lets say for a particular row, that the cell of the third date column for example is not filled in - user leaves blank. Is there any way that I can have my fourth column ("Total Days&quot show nothing -- so it's simply blank -- rather than displaying "#VALUE!" or an inaccurate negative number that I keep getting.

Thanks again for any help.

 

[GeekGirlau]

=IF(C3>0,C3-A3,"&quot

The IF function has three parts:
the test (is there anything in cell C3?),
what to do if the test is true (C3-A3),
what to do if the test if false (insert nothing).

 

[5656]

ok ok, ok...I'm absolutely terrible at programming so here's my problem now: 2 of the 3 date columns could possibly be left blank...is there a way to show nothing in the "TOTAL DAYS" column if 2 of my 3 date columns are left blank (vs. only one being left blank as I stated in previous email)...thanks again !!

 

[Hasit]

Try this:

=IF(B1>0,IF(C1>0,C1-A1,"&quot,"&quot

This is a nested IF function and all I am doing is testing 2 cells, one after the other.