| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using a year from a date
I am working on a seniority list and want excel to list the number of people
hired in each specific year. What is the formula I would use to just extract that year of hire information? Sheet 1 lists all the seniority dates and sheet 2 shows all the statistics so i have to refer to sheet 1 in the formula. I was trying to use =countif(senioritylist!d3:d58,"="(year)1977) and so on for consecutive years, but that is not working. -- andy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determine year over year date for comparison | Excel Worksheet Functions | |||
| Converting a year date into a specific day date | Charts and Charting in Excel | |||
| pick up date, month and year from a date | Excel Discussion (Misc queries) | |||
| Year-to-date year to date formula | Excel Worksheet Functions | |||
| Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
Threaded Mode
