How to come up with a % of aging orders

[jabersold]

What formula would look at a page of information with a column that contains dates and tell me how many of them (the percentage) is outside of yesterdays date by 12p.

thank you in advance for the help.

 

[Captain_Conman]

Do your cells contain the date and time/what do they look like?

This formula will give you the percentage of dates in column A that fall before yesterday's date.

=COUNTIF(A:A,"<"&TODAY()-1)/COUNT(A:A)

 

[jabersold]

yes the date and time is in the line

Thank you for the follow up