C
CP
How can I show an empty result if Cell E4 is empty
=DATE(YEAR(D4),MONTH(D4)+E4,DAY(D4))
many thanks
=DATE(YEAR(D4),MONTH(D4)+E4,DAY(D4))
many thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JP Ronse
Hi CP,
Do you mean ...
=if(E4="","", DATE(YEAR(D4),MONTH(D4)+E4,DAY(D4)))
Wkr,
JP
Do you mean ...
=if(E4="","", DATE(YEAR(D4),MONTH(D4)+E4,DAY(D4)))
Wkr,
JP
S
Sean Timmons
=if(E4="","",DATE(YEAR(D4),MONTH(D4)+E4,DAY(D4)))
C
CP
Thanks for that
Sean Timmons said:=if(E4="","",DATE(YEAR(D4),MONTH(D4)+E4,DAY(D4)))
C
CP
Thanks for that
JP Ronse said:Hi CP,
Do you mean ...
=if(E4="","", DATE(YEAR(D4),MONTH(D4)+E4,DAY(D4)))
Wkr,
JP