% Date calculation

Emily Trebilcock

Hello,

I need to create a % calculation for the number of dates meeting a 'launch' date. What is the best formula to use for this? I will have a long list of dates and I need one column to calculate how many of them are equal to or less than a launch date (25/03/2021).

Any guidance would be greatly appreciated.

Thanks,

Emily

Paul Newcome

Try something like this...

 

=COUNTIFS([Date Column]:[Date Column], @cell < DATE(2021, 3, 25))

 

This will give you the count of how many dates are before 25/3/21. You can then divide that by the total to give you a percentage.

Emily Trebilcock

Thank you, it worked!

Paul Newcome

Excellent! Happy to help.