If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Select records by month
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. |
#2
|
|||
|
|||
Select records by month
"PlarfySoober" wrote in message ... 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. -- DB. |
#3
|
|||
|
|||
Select records by month
Not clear - do you want to list employees who joined on 6/16/2008 ??
-- Gary''s Student - gsnu200903 "PlarfySoober" wrote: 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. |
#4
|
|||
|
|||
Select records by month
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 -- Gary''s Student - gsnu200903 "PlarfySoober" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|