how to write formulas to get the answer of "?" in pic below.


The date are in string (manually typed)

I want to count how many different date in a month

for example 22-jan-20 and 21-jan-20 are counted as 2

Please help me for the smartsheet formula

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!