Determining number of days between dates
 

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.

One way:

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

Where D1 contains your "specific date"

In article ,
Debbie wrote:

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.

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)


"Debbie" wrote in message
...
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.

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

"JE McGimpsey" wrote:

One way:

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

Where D1 contains your "specific date"

In article ,
Debbie wrote:

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?

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

In article ,
Debbie wrote:

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