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?
First Question after having been gone from Ex-Ex for a long time! Howdy All!