Data Validation formula for certain dates and text

[kosherboy]

Hello all!
I am trying to create the following formula argument in Data Validation but without much luck:
If entering date in Cell "A1" then date must be anywhere between January 1st 2014 to December 31st 2014, and the only text that can be entered, if not entering date, is "N/A".

Thank s in advance

[JBeaucaire]

Allow: Custom
Source: =OR(A1="N/A", AND(A1>=41640, A1<=42004))

[ragulduy]

Try:
=IF(A1="N/A",TRUE,YEAR(A1)=2014)

[kosherboy]

Hi guys, thanks! Both formulas don't seem to be working out the issue. I tried typing today's date and got error message.

[ragulduy]

I tried it on a test first and it seemed ok, take a look at the attached example?

[kosherboy]

Silly me! I used your formula in a different cell and didn't enter the cell correctly in the formula.
Thanks for helping me out ragulduy and JBeaucaire

[JBeaucaire]

As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.