Ignoring Text in Date field

Good day!
I am using the Excel (2007) WorkDay() function to calculate dates from a schedule.
However some of the lines have text instead of Dates.

How can I format the formula to ignore text.
I use the =if(A1="",""  etc.. if it is blank. But it #VALUE errors out if there is text.
Would an =IF(ISTEXT work?

Thanks!

First Question after having been gone from Ex-Ex for a long time!  Howdy All!
RayLBaileyAsked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
=IF(E2="","",if(istext(k2),"",WORKDAY(K2,-TimeDate!$C$5,)))
0
 
RunriggerCommented:
how about exploring the IFERROR function;

=IFERROR(WORKDAY(A1),"Do something else")
0
 
Saqib Husain, SyedEngineerCommented:
Yes

=istext(your_formula)

should work
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
RayLBaileyAuthor Commented:
Okay, should have posted my formula so you can help me figure out how to use the IsError
.
=IF(E2="","",WORKDAY(K2,-TimeDate!$C$5,))
0
 
RunriggerCommented:
try this

=iferror(WORKDAY(K2,-TimeDate!$C$5,),"")
0
 
INHOUSERESCommented:
=IF(ISTEXT(A1),"",WEEKDAY(A1))
0
 
RayLBaileyAuthor Commented:
I accepted the ISError because it handles if there is a bad number in the field instead of DATE or t text.

Thanks!

Ray
0
 
RunriggerCommented:
ermmm, looks like you awarded points to the wrong one then :-(
0
 
RayLBaileyAuthor Commented:
ARRRRGH!  Sorry!
0
 
RunriggerCommented:
It's not a problem, the focus for me was to offer help to you, not to earn points, and I am happy that we were able to do so.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.