Return empty cell/blank

[Marc]

I have this formula to calculate the difference with a
date and now: H4: =datedif(g4,now(),"d")

G4= 6 JUL 04 H4= 1

What I want is if the cell in G is left blank, the cell H
should have nothing in it. what is the formula?

Thanks Marc

 

[Peo Sjoblom]

First you don't need to use DATEDIF for counting days, secondly unless time
is involved there is no need for NOW, you can use TODAY() instead

=IF(G4="","",TODAY()-G4)

should do what you want

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Guest]

Good day, I tried it at work with Excell 2000 adn it
didn't work but I tried it at home with Excell 2002 and it
works.