Return empty cell/blank

  • Thread starter Thread starter Marc
  • Start date Start date
M

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
 
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)
 
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.
 
Back
Top