Thread
:
Empty Cell
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons
external usenet poster
Posts: 1,696
Empty Cell
=if(E4="","",DATE(YEAR(D4),MONTH(D4)+E4,DAY(D4)))
"CP" wrote:
How can I show an empty result if Cell E4 is empty
=DATE(YEAR(D4),MONTH(D4)+E4,DAY(D4))
many thanks
Reply With Quote
Sean Timmons
View Public Profile
Find all posts by Sean Timmons