Data Validation for date in current year

[BigD]

Ninjas,

I am trying to validate if a date entered is in the current year.

For an example, I have a cell (F1) that reports the current date using "=today()". I am trying to figure out what formula to use in data validation to ensure whatever date is entered is in the same year of the current year.

This is my effort:

=K12<>YEAR(F1)

Not with any success though. Thank you for viewing.

Dustin

 

[NARAYANK991]

Hi Dustin ,

Just compare the years , as in :

=YEAR(K12) = YEAR($F$1)

Narayan

 

[BigD]

Thank you. I was over thinking it.