Thread: Filter by Date of Birth
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
M Kan M Kan is offline
external usenet poster
  
Posts: 169
Default Filter by Date of Birth
If all of your data is in Excel, you can add a helper row and use the formula
=Month(ref) to generate a month value (1-12) and then filter on that.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Naomi" wrote:

I work in a medical office and need to do chart review by birth date. How
can I filter my table or a pivot table by date of birth within a month range.
Example: all dates of birth in October, November, December for any year!

PLEASE HELP ME!
--
Naomi
Reply With QuoteReply With Quote