Use the Isblank & Iferror Excel function With Date/Time Cell reference

[msvoboda27]

Hello,
I'm ashamed to say having a harder a much time then I hoped to create an excel formula for a work report and ask the experts fo your help. Please!
I have a straight forward excel table and reference a date/time/AM/PM from one cell and perform a text string function to break out the yr/month/date and time of day. If the date is added to the cell the text string function works properly and populates the data. If I have no date I am still getting data populated. My goal is to have no data appear in the corresponding cells that I'm using the text string function when no date is in the date cell I'm referencing.
What do I need to do so that if no date populates it shows data no data? I thought a iferror or isblank but haven't figured it out.
Thank you!

date	Yr	Month	Day	time of Week
11/22/19 12:10 PM	shows (2019)	shows: (Nov)	Shows: (Friday)	(PM)
empty cell	shows: (1900)	Shows: (Jan)	Shows: (Saturday)	(AM)

Obviously I am doing something wrong but unsure how to address. can someone please help, Below are my formulas

A	Date	Yr	Month	Day	Time of Day
2	11/22/219	=TEXT($A2,"yyyy")	=TEXT($A2,"mmm")	=TEXT($A2"dddd")	=TEXT($A2,"AM/PM")

 

[DanteAmor]

Try

=IF($A2="","",TEXT($A2,"yyyy") )

 

[msvoboda27]

You are absolutely correct that resolved. it. Thank YOU. It makes so much more sense after you see the answer
Thanks for taking the time to respond.
Sincerely, Michael

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.

 

[gavino]

You can use ISBLANK on Dante's formula as well. Try =IF(ISBLANK(A2),"",TEXT($A2,"yyyy"))

 

[Fluff]

@gavino
ISBLANK will return False if the cell contains a formula that returns "", whilst DanteAmor's formula will treat it as empty.

 

[msvoboda27]

Perfect I will test isblank later today, I really love learning about new things Excel can do, it's really limitless!
Kind regards, Michael