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.

Format the cells in column C by General or Number instead of Date.
And the formula could be =IF(ISBLANK(B1),Calulation1,B1-A1)

Ola

One way:

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

Where D1 contains your "specific date"

In article <[email protected]>,
Debbie <[email protected]> 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" <[email protected]> wrote in message
news:[email protected]...
> 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 <[email protected]>,
> Debbie <[email protected]> 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 <[email protected]>,
Debbie <[email protected]> wrote:

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