| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using a year in a date
I have a list of employees and have calculated their retirement dates. this
among other things are calculated on sheet 1 (labeled senioritylist). On sheet 2 I want to calculate the percentage of employees that have reached their retirement date or are within 5 years of retirement, and then do the same in the 5-10 year retirment group, etc. I was trying to use =countif(senioritylist!k3:k58,"(today()+365.25*5)" ) but that does not work. What am I doing wrong? -- andy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determine year over year date for comparison | Excel Worksheet Functions | |||
| If a date range contains a leap year (date) | Excel Worksheet Functions | |||
| Sorting a date by month, date and then year. | 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
