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

Need Help with a VBA subroutine	0	Jul 27, 2020
Location Oriented Formula	1	Sep 23, 2009
SUMPRODUCT formula I think w/ wild card & number vs number as text	8	Feb 18, 2014
Combine Sumifs with Subtotal	0	Apr 2, 2019
Leave final cell blank	2	Nov 13, 2009
Average of Years employed	5	Jul 28, 2009
how to undo scrolling tied to a single cell	1	Feb 23, 2010
Ignoring empty cells	6	Mar 6, 2008

Ask a Question