Hi @MarieR ,
Regarding your question about using formula column as a date and creating automations from it.
At the moment, there’s a limitation in the native support for this.
However, 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!
You can ask any questions you need clarifications on.