Adding Dates Help

[David M]

Hi All,

Pleae tell me if I have this correct =IF(ISERROR(R8-Q8),"")

What I need to do is get the difference between dates to
show a progression of time from one state of being to
another. The reason for the ISERROR is so that when there
is no two dates to calculate, the return won't be the
VALUE! error. What I am getting is when it finds dates
that are the same IE,
1/1/04-1/1/04...the value should be returned as
Zero...what I get is the value FALSE....what am I missing??

The goal is to get the difference between the dates no
matter if they are the same or not.

Thanx for your help

David

 

[Andy B]

Hi

You've missed off part of your IF function. The syntax is:
=IF(test,result if test true, result if test false)

Try this:
=IF(ISERROR(R8-Q8),"",R8-Q8)

 

[David M]

Worked like a charm...thank you so much

-----Original Message-----
Hi

You've missed off part of your IF function. The syntax is:
=IF(test,result if test true, result if test false)

Try this:
=IF(ISERROR(R8-Q8),"",R8-Q8)

--
Andy.





.