| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating a percenatge based on dates
Hi
I am trying to calculate a percentage in a training records spreedsheet based on the dates that personnel have completed their training. If for example I have 20 personnel whose traing records show that they have completed their training in the last 12 months and 5 who are out of date the result should be 80% but I can't seem to get the formula correct. Please can anyone help me. Very many thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating a percenatge based on dates
Hi,
Lets say you training dates are in A1:a20. Try this formatted as % =1-COUNTIF(A1:A20,"<" & TODAY()-365)/COUNT(A1:A20) Mike "Oldmanoutofhisdepth" wrote: Hi I am trying to calculate a percentage in a training records spreedsheet based on the dates that personnel have completed their training. If for example I have 20 personnel whose traing records show that they have completed their training in the last 12 months and 5 who are out of date the result should be 80% but I can't seem to get the formula correct. Please can anyone help me. Very many thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating differentials based on dates | Excel Worksheet Functions | |||
| percenatge increase in values across multiple cells | New Users to Excel | |||
| Calculating cells based on dates | Excel Worksheet Functions | |||
| Need help with a formula for calculating based on a rage of dates | Excel Discussion (Misc queries) | |||
| Calculating Due Dates Based on Payments | Excel Worksheet Functions | |||
Linear Mode
