View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Need to Select Individual Records Based on Birthdays in Current Mo

Assuming birthdates are in column C

In a helper column enter =MONTH(C1)

Copy down.

Autofilter on Month number..........9 is October.

F5SpecialVisible CellsOK

Copy and paste the visible cells to somewhere.


Gord Dibben MS Excel MVP

On Wed, 7 Oct 2009 13:53:02 -0700, PlarfySoober
wrote:

That sort of says it. I need to create a list, probably on the same sheet,
with the names & birthdays of everybody whose birthday, e.g., falls in
October.

Trying to do it by hand is embarrassingly inaccurate.

Any suggestions would certainly be welcome.

Don.