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.
|