[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 264
  • Last Modified:

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!
0
RayLBailey
Asked:
RayLBailey
  • 4
  • 3
  • 2
  • +1
1 Solution
 
RunriggerCommented:
how about exploring the IFERROR function;

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

=istext(your_formula)

should work
0
 
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
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

 
RunriggerCommented:
try this

=iferror(WORKDAY(K2,-TimeDate!$C$5,),"")
0
 
INHOUSERESCommented:
=IF(ISTEXT(A1),"",WEEKDAY(A1))
0
 
Saqib Husain, SyedEngineerCommented:
=IF(E2="","",if(istext(k2),"",WORKDAY(K2,-TimeDate!$C$5,)))
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now