Frequencies of occurrences of 0-9 over a dynamic range

I am trying to create a formula that looks at column A and all dates in the past back to a specified dynamic number in cell G3, and returns a value from Column B of the number of occurrences of each number from 0 to 9 during that dynamically specified number of days in the past.




TIA

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

Welcome to the Forum clarksamclark!

Most people will not want to type in dozens of rows of data to test a formula for you. Please attach your actual Excel file (see yellow banner at the top of the page).

Also I am updating your title to describe what your objective is, not how you think it should be done. (Please see our rules and guidelines on thread titles.)

I don't think you want EDATE.


https://support.microsoft.com/en-us/...5-753ae47ee4f5

This article describes the formula syntax and usage of the EDATE function in Microsoft Excel.

Description

Returns the serial number that represents the date that is the indicated number of months before or after a specified date (the start_date). Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue.

Syntax

EDATE(start_date, months)

The EDATE function syntax has the following arguments:

Start_date Required. A date that represents the start date. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.

Months Required. The number of months before or after start_date. A positive value for months yields a future date; a negative value yields a past date.


Try, copied down:

Formula:

Please Login or Register  to view this content.

Or, all in one

Formula:

Please Login or Register  to view this content.

You're welcome.



If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.