Select records by month

[PlarfySoober]

Each month we need the identities of employees who joined the company 3
months and one year ago.

It is nonsense to go through the list manually, but I can't find a way to do
it automatically. Ideally, I would end up with a separate spreadsheet, or
even a separate section of the existing spreadsheet, that contains the names
and other data from persons who match the criteria:

Name, Hire Date, Job Title, Department, month FOR Records WHERE (Month of
Hire Date) = (This Month - 3 months) OR (Month of Hire Date) = (This Month
-12 months).

And collects them all in a nice, tidy box I can ship to the relevant
managers. Sorted by Department. Lightly scented with lavender.

Seems simple, but is beyond me. I'm a real newby at this, so if you use
abbreviations, I am guaranteed not to understand them.

Thanks in advance.

 

[DB.]

Each month we need the identities of employees who joined the company
3
months and one year ago.

It is nonsense to go through the list manually, but I can't find a way
to do
it automatically. Ideally, I would end up with a separate spreadsheet,
or
even a separate section of the existing spreadsheet, that contains the
names
and other data from persons who match the criteria:

Name, Hire Date, Job Title, Department, month FOR Records WHERE (Month
of
Hire Date) = (This Month - 3 months) OR (Month of Hire Date) = (This
Month
-12 months).

And collects them all in a nice, tidy box I can ship to the relevant
managers. Sorted by Department. Lightly scented with lavender.

Seems simple, but is beyond me. I'm a real newbie at this, so if you
use
abbreviations, I am guaranteed not to understand them.

Thanks in advance.

I can't help you with your Excel problem - there are some real
geniuses who come here day after day to do that.
But if you're puzzled by acronyms and abbreviations I recommend
this:

http://acronyms.thefreedictionary.com/

I have a shortcut to it on my desktop, and visit it frequently.

HTH.

 

[Gary''s Student]

Not clear - do you want to list employees who joined on 6/16/2008 ??

 

[Gary''s Student]

With join dates in column A, in B2 enter:

=IF(TODAY()=DATE(YEAR(A1)+1,MONTH(A1)+3,DAY(A1)),1,0) and AutoFilter by
column B.

Column B becomes 1 on the join date + 1 year + 3 months