Formula for Dates Calculation


I am trying to find out how I can create formulas for the below.

Kickoff Date - Number of rows with a kickoff date by month? IE Count of projects in a column with a kickoff date in Jan, Feb, March etc

Average days in IMPL - The average number of days for all projects. IE: kickoff day in my sheet vs current day for all rows in the sheet summed.

If I have 2 projects with different kickoff dates I want to be able to know the average time since kickoff of both summed in 1 number. Not sure if this is even possible or I would need to just calculate myself. I previously just created a "datedif" macro in excel to find the total days then divided it by the total projects


Best Answers