You could build a pivot table around the month element of the birth date.
This would identify the children who birth datesare due in the current month.
Matt
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.
--
Matt Lynn
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1