Count Dates in a cell

Is it possible to count the number of dates (mm/dd) that show up in a cell? Would the format of the dates need to include a year as well? In the example below I have two dates in the cell.



If this is not possible, how would I count the number of dates in a date column


Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @Bob Kernan

    I hope you're well and safe!

    Here's an excellent solution from RossL that could work.

    I came up with a solution, it is not the most elegant but it works. below is a link to the sheet I made. what it is doing is looking for the key word and using helper rows to find the start of that word and then the next column in the line will find the next one by start its search after the first word, then the start of the next occurrence ect. the green column counts all the columns that have a position noted.

    https://app.smartsheet.com/b/publish?EQBCT=78c55d4176554b85afc0ef5bf456f4b1

    Did that work/help?

    I hope that helps!

    Be safe and have a fantastic weekend!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!