Cells A1:J1 contain dates formatted to display the year only.
Cell A2 I would like to enter a year.
Then I need a validation formula that would evaluate if that year is present in cells A1:J1
Would someone please help with this?
thanks,
Ken
Cell A2 I would like to enter a year.
Then I need a validation formula that would evaluate if that year is present in cells A1:J1
Would someone please help with this?
thanks,
Ken