help with formula

cjbarron5 · May 30, 2008

I am using =H4+30 where h4 is my date cell for my quote invoice but when h4
is blank I get 1/30/00 how can I make it show blank when h4 contains no
information

Gary''s Student · May 30, 2008

=IF(H4="","",H4+30)

Mike H · May 30, 2008

Maybe

=IF(H4="","",H4+30)

Mike

cjbarron5 · May 30, 2008

Thank You very much works great

David Biddulph · May 30, 2008

=IF(H4="","",H4+30)

help with formula

cjbarron5

Gary''s Student

Mike H

cjbarron5

David Biddulph