Blank Dates reading as Pass

[CRogers22]

Hello:

I am running a formula between two dates which is a >=30 and it seems if the date is blank its reading it as less than 30.

IF ToNumber([Test 2 Days])<=30
OR ToNumber([Test 2 Days 2])<=30
THEN 'Pass'
ELSE 'Fail'
ENDIF

How do I write it to make it fail if its fails the first test and second test return (Blank) as there is missing a date.

[nagakavyasri · Accepted solution]

@CRogers22 

[CRogers22]

@nagakavyasri       Thank you

[CRogers22]

Hello @nagakavyasri sorry for bringing this one back up but wanted to see if you could help me understand the formula. 

I'm running into the same problem in another report but has more dates then the previous one.

Formula I started with.

more dates to take into account. I cant figure out how add the extra dates to the formula you helped me with.

Any help would be appreciated.