Determining number of days between dates

[Guest]

Hi, I have 2 date columns. One is a start date (column A), the other column
contains withdrawl dates(column B) (many cells in this column are blank). In
the third column I want to determine the number of days between column B and
column A but if column B is blank I want to use a specific date to subtract
from the start date.

Any suggestions?
Thanks.

 

[JE McGimpsey]

One way:

=IF(B1<>"",B1,D1) - A1

Where D1 contains your "specific date"

 

[Bob Phillips]

Assuming start date in A1, withdrawal date in B1, and the specific date in
C1, then try

=(IF(B1<>"",B1,C1)-A1

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Sounds good but it's giving me a VALUE error?
Any suggestions?

 

[JE McGimpsey]

Any suggestions?

Don't use the space bar to clear B1. Text will cause an error with a
math operator.

Or else use something like

=IF(LEN(TRIM(B1))=0,D1,B1) - A1