I’d like to add a similar query.
Using a Formula created date, the automation is giving it a value of one day later.
The Formula date is correct, but running the Automation adds a day, leading to the date being misplaced on the calendar (goal of automation).
I do not have this issue with standard dates running through the automation.
I’ve modified time/date formats- in the table & automation, modified the formulas, but the additional date still pops up. I do not think that switching to GMT or subtracting time will give a consistent outcome.
p.s - Sharing and Importing a Calendar view does the same thing. Correct dates in the Airtable Calendar view & formula dates are 1 day later in Synced calendar.