I have a rather large spreadsheet which tracks hospital patient admissions. I
need to identify only those who are admitted in the current month (say
November), but I am getting all patients admitted in November for prior
years, 2005, 2004, etc.

Is there a function that can look at the entered month/year of admission and
compare it with the current month/year to result in a TRUE condition so that
I may identify these individuals?

Thanks in advance,