Returning value based on date

[Phil_L]

I am after a formula which I think would be very simple, but I cannot for the life of me find. So thank you in advance if someone replies.

Basically,

When someone types a date in A1, B1 would return a value (1 for example), if there is nothing in A1, B1 would be blank. If any other text is written in A1, it returns NA.

Hope this makes sense.

I currently have =IF(ISNUMBER(A1),1,"") in the B1 cell and that works ok. I just cant figure out what to put at the end if any other text is entered to display N/A.
(I suppose there is a better way of doing it)

Again, thank you in advance

Phil

 

[Fluff]

You're welcome & thanks for the feedback.