Oops, Formula should read:
"=IF(MONTH(B2) = MONTH(NOW())+1,"Yes","")"

"Lionel H" wrote:

I don't know what your worksheet layout is, so play about with this:
I created a dummy worksheet
A1 = "Child"; B1 = "Birthday"
A2 = "child 1"; B2 = "23/12/1979"
A3 = "Child 2"; B3 = "06/10/1981"
A4 = "Child 3"; B4 = "30/11/1983"
.
.
.
now add in column C:
C1 = "Birthday next month?"
C2 = "=IF(MONTH(B2) = MONTH(NOW()+1),"Yes","")"
Drag C2 over C3 to end of column (in this case C4)
Today is still in September so C2 & C4 are empty; C3 = Yes.
If you don't find this reply till Weds next week, C2 & C3 will be empty and
C4= "Yes"
Autofilter on "Yes" in column C to finf all children with birthdays next
month.

"csd1126" wrote:

We have case reviews that are driven by the Birthdates and Ages of our
children. Is there a way to have excel notify you when a child has a
birthdate (review) due?
We have hundreds of children to monitor and to scroll through data is too
time consuming. Are there pop-up alerts or a way to set conditions to notify
us.