Your very clear statement of the requirement makes this easy:

=IF(AND((MONTH(A1)=11),(YEAR(A1)=YEAR(NOW()))),TRU E,FALSE)
This is good for November.


=IF(AND((MONTH(A1)=MONTH(NOW())),(YEAR(A1)=YEAR(NO W()))),TRUE,FALSE)
This is good for any month
--
Gary's Student


"Jetlag5549" wrote:

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,