Empty Cell

CP · Sep 2, 2009

How can I show an empty result if Cell E4 is empty

=DATE(YEAR(D4),MONTH(D4)+E4,DAY(D4))

many thanks

JP Ronse · Sep 2, 2009

Hi CP,

Do you mean ...

=if(E4="","", DATE(YEAR(D4),MONTH(D4)+E4,DAY(D4)))

Wkr,

JP

Sean Timmons · Sep 2, 2009

=if(E4="","",DATE(YEAR(D4),MONTH(D4)+E4,DAY(D4)))

CP · Sep 2, 2009

Thanks for that

Sean Timmons said:
=if(E4="","",DATE(YEAR(D4),MONTH(D4)+E4,DAY(D4)))

CP · Sep 2, 2009

Thanks for that

JP Ronse said:
Hi CP,

Do you mean ...

=if(E4="","", DATE(YEAR(D4),MONTH(D4)+E4,DAY(D4)))

Wkr,

JP

Location Oriented Formula	1	Sep 23, 2009
Leave final cell blank	2	Nov 13, 2009
Average of Years employed	4	Jul 28, 2009
how to undo scrolling tied to a single cell	1	Feb 23, 2010
Ignoring empty cells	6	Mar 6, 2008
SUMPRODUCT - Multiple Criteria	1	Mar 19, 2012
Formula or Function?	4	Aug 12, 2006
Nested IF	2	Oct 26, 2008

Ask a Question