Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

looking for an Iferror formula that will bring back a blank value if a date is not listed. Currently using the following but want to add an Iferror statement: =TEXT(H2,"DDDD"). H2 is the raw date ex. 2/8/18. I tried =IFERROR(TEXT(H2,"DDDD"),"") but it keeps returning "saturday" instead of a blank cell. Any help is appreciated.
Solved by F. Q. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 08/02/2018 - 12:38
Hello! Welcome to Excel Chat.
User 08/02/2018 - 12:39
Good Morning
Excelchat Expert 08/02/2018 - 12:40
Morning. How may I help you with?
User 08/02/2018 - 12:40
having issues with an iferror statement returning a name instead of a blank cell
Excelchat Expert 08/02/2018 - 12:40
As I understand you want to check if a cell has date or not. If it has a date then it should return date, else cell should be blank.
User 08/02/2018 - 12:40
Excelchat Expert 08/02/2018 - 12:40
Excelchat Expert 08/02/2018 - 12:41
Let me think of a solution for you. Give me few moments please.
User 08/02/2018 - 12:41
Excelchat Expert 08/02/2018 - 12:44
The function is checking for date correctly, I need to apply your IF condition to it.
Excelchat Expert 08/02/2018 - 12:47
Please see the cell B2 with the required formula.
User 08/02/2018 - 12:47
let me try it one second please
Excelchat Expert 08/02/2018 - 12:47
Sure. Once you verify that, I will explain it.
User 08/02/2018 - 12:49
this isn't what I am looking for, let me provide you a better example
Excelchat Expert 08/02/2018 - 12:49
User 08/02/2018 - 12:51
does this make more sence
Excelchat Expert 08/02/2018 - 12:51
So in cell E4 you want a blank value as D4 is blank or not a date.
User 08/02/2018 - 12:51
my spreadsheet will have some cells without a date and I don't want the day of the week populating and just reflecting a blank cell
User 08/02/2018 - 12:52
Excelchat Expert 08/02/2018 - 12:52
OK. Let me modify the formula.
User 08/02/2018 - 12:52
Thanks for your help
Excelchat Expert 08/02/2018 - 12:53
Please see my formula in B1 cell now.
Excelchat Expert 08/02/2018 - 12:53
I am glad that I could help you today.
Excelchat Expert 08/02/2018 - 12:53
Hope to see here again soon.
Excelchat Expert 08/02/2018 - 12:53
I would like to explain the solution if you have time.
Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc