On Tue, 25 Mar 2008 12:31:12 -0700, Martyn
wrote:

Hi everyone

I have two colums with dates in and I want to subtract one from the other so
so I can get hte dumber of days between the two, this is the east part. The
problem I have is when one of the colums is blank I want to use todays date
so I can avoid #VALUE! being returned, I been reading a looking up posts here
for the best part of two hours and can not find the answer, can anyone help
me please?

Many thanks
Martyn


Try this:

Replace B1 with IF(ISBLANK(B1),TODAY(),B1)

To get the number of days between two dates you just have to subtract
them.

=IF(ISBLANK(B1),TODAY(),B1)-IF(ISBLANK(A1),TODAY(),A1)

Hope this helps / Lars-Åke