Calculating a percenatge based on dates

  • Thread starter Oldmanoutofhisdepth
  • Start date
O

Oldmanoutofhisdepth

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
 
M

Mike H

Hi,

Lets say you training dates are in A1:a20. Try this formatted as %

=1-COUNTIF(A1:A20,"<" & TODAY()-365)/COUNT(A1:A20)

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Functions & Formatting 6
Help with Calculating Dates 1
Auto column insertion based on a number 0
Automation of scanned file storage based on content 0
Calculating an average of data between two dates 1
Expiration dates 7
create manufacturing demand based on customer delivery 0
Color a cell based on column date and row content 2

Top