Formula to count number of child rows that with dates that fall in last 60 days
Hello, I am working on a sheet and would like a "helper" column to provide me with a number in the parent row that counts to the number of child rows with a date (from the "Date Shared" column) that falls within the last 60 days.
The goal of this is so that I can pull a report that lists any rows that list dates in the last 60 days AS WELL AS the parents of those rows. If there is an easier way to report this, I am all ears.
I am not very familiar with formulas and have been trying out different things with no success.
Any advice on how to write this formula?
Help Article Resources
Check out the Formula Handbook template!