Hi @dspry,
Regarding your question about using formula column as a date and creating automations from it.
If you are looking for a well rounded approach to addressing this, we’ve just published a detailed walkthrough in the community that directly addresses this challenge. It shows you how to use your formula column results to kick off automations.
You might find it really helpful: Copy formula result to other columns and trigger automations
Hope this helps you out!