Percentage of column within 1yr from today

[APR1209]

Good morning all,
I have created a training tracker with completion dates entered in the cells. I now want to calculate the percentage of values in a column that are within 1yr from today. It is important that it is rolling and not within a static date range.
V/r,
Anthony

 

[Joe4]

Welcome to the Board!

Is this one year in the future, or in the past?
Which column is this?
What row does the data start in?
Are there any blanks in these cells, and if so, are they to be counted in your percentage?

 

[APR1209]

One year in the past.
Column J
Starts on row 3, ends on row 69.
There are blanks that I DO NOT want counted, additionally there are "N/A"s that I DO want counted.
thank you for your quick response

 

[Joe4]

Try this formula:

=COUNTIF(J3:J69,">" & EDATE(TODAY(),-12))/COUNTA(J3:J69)