% Date calculation
Options
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
Comments
-
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.
-
Thank you, it worked!
-
Excellent! Happy to help.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
