I made this a feature request, as it appears from Help documentation that it cannot currently be done.
I have dates in one table which are in a lookup field (so Assets in a table of assets find out their deadline from the deadline of the project in which they’re included (Projects are in a separate table).
So I want to show the Assets in a Calendar view showing when they need to be done, but the date field for the calendar view isn’t a Date field—technically it’s a Lookup field—so it doesn’t show as an available date. If I copy the value from the Lookup field to a dummy Date field I run into the problem Y_K posted: that a Formula Field doesn’t work (either) for the purposes of the Calendar view.
Basically, Airtable users need to use any field formatted as Date as input for the Calendar View.
Thank you!! Airtable is miraculous. (And PLEASE don’t let anyone buy the company!)