How not to count a field with words in forumla

[nathanexcelhelp]

Hi all,

I have a formula in column C that calculates the working days between 2 days (Column A to B). If there is no value in column B I want it to warn me that "No report date recorded".

In column D I want to calculate if the days counted in column c are within target. In this instance the target is 25 days or less.

I have done this for both of the above in the attached.

I am then going to count all the 1's in D as these are within target. However when no date has been entered in B, it is correctly warning me, but it is also considering the value to be less that 25. If there is no value in B, I want it to consider this as a within target value (to show a 1 in D, rather than a 0)

[Aardigspook]

Two possibilities:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[Phuocam]

Or try this ...

=--(N(C2)<=25)