How to change the formula to get the avg of column if after 1/1/2023

The formula I have is pulling all the dates but I want only get the avg of the cell if date is after 1/1/23:

=AVG({Hired Range 1})

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!