Calculating the days between two dates
 

I have dates in several columns that track how long various processes take.
These dates are manually added however the process may still be incomplete
thus leaving a blank in that column. These blank columns are causing my
calculations to have incorrect #'s. Is there a way I can leave a cell blank
without having this happen?

In this example this process took 39 days for line 1 but line 2 wasn't
complete so no date has been inserted because redlines aren't complete this
causes a long incorrect date. Thanks so much again.

A B C

In for Redlines Back from Redining

1- 2-Feb-09 26-Mar-09 39
2- 4-Nov-08 2837

Calculating the days between two dates
 

Try the below

=IF(COUNT(A1:B1)=2,B1-A1,"")

or if you are using another formula like networkdays()
=IF(COUNT(A1:B1)=2,yourformula,"")


If this post helps click Yes
---------------
Jacob Skaria


"pandd15" wrote:

I have dates in several columns that track how long various processes take.
These dates are manually added however the process may still be incomplete
thus leaving a blank in that column. These blank columns are causing my
calculations to have incorrect #'s. Is there a way I can leave a cell blank
without having this happen?

In this example this process took 39 days for line 1 but line 2 wasn't
complete so no date has been inserted because redlines aren't complete this
causes a long incorrect date. Thanks so much again.

A B C

In for Redlines Back from Redining

1- 2-Feb-09 26-Mar-09 39
2- 4-Nov-08 2837

Calculating the days between two dates
 

I presume in column C you have formulas like =B3-A3?

Change this to =IF(B30,B3-A3,"NA")

Sam

"pandd15" wrote:

I have dates in several columns that track how long various processes take.
These dates are manually added however the process may still be incomplete
thus leaving a blank in that column. These blank columns are causing my
calculations to have incorrect #'s. Is there a way I can leave a cell blank
without having this happen?

In this example this process took 39 days for line 1 but line 2 wasn't
complete so no date has been inserted because redlines aren't complete this
causes a long incorrect date. Thanks so much again.

A B C

In for Redlines Back from Redining

1- 2-Feb-09 26-Mar-09 39
2- 4-Nov-08 2837