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
correct
Excelchat Expert
08/02/2018 - 12:40
Ok.
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
ok
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
Ok.
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
correct
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.
