ExcelBanter - help with formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - help with formula (https://www.excelbanter.com/excel-discussion-misc-queries/189438-help-formula.html)

cjbarron5

help with formula

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

help with formula

=IF(H4="","",H4+30)
--
Gary''s Student - gsnu200789

Mike H

help with formula

Maybe

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

Mike

"cjbarron5" wrote:

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

cjbarron5

help with formula

Thank You very much works great

"cjbarron5" wrote:

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

David Biddulph[_2_]

help with formula

=IF(H4="","",H4+30)
--
David Biddulph

"cjbarron5" wrote in message
...
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

All times are GMT +1. The time now is 02:40 PM.