Converting a text (MONTH YEAR) into a date
I am trying to convert a text box that shows the month and year only in a column. So if the cell with the text of “October 2022” is shown, I want a different column to produce “10/01/22”
I would also want to use this date column for automations, so I am curious to know if column formulas could be used as triggers for automations.
To better explain based on the previous example, if October 1st 2022 is the trigger for the automation would it run?
Any insight helps! Thank you!
Help Article Resources
Check out the Formula Handbook template!