Conversion of the text into a date format


The attached table contains the columns ‘Date, From, To’. The data in these columns are in text format and I would like to convert them into dates so I can use them to create a calendar view. I would be more than grateful for any help. Thanks.


It can be done with one large formula, but I think it is better to use additional column you can hide:

1 Like


Thank you but I can’t copy the document to see your solution. For unknown reasons there is no copy doc button


Changed access mode to edit, cant you see formulas in columns?


Now I can. Thank you. I still have a lot to learn. On the other hand, I would like to know how to learn the formulas. I am a psychologist by education and the first steps are really hard for me. Anyway, I am not going to give up.

One more question: When I have the calendar view, the months change every two months and I can’t move months forward but only backwards. Why is that?


Could you show this problem with some example, please?


I’d love to, but I don’t know how. Maybe I will ask you differently. Can you turn on the calendar view for the month of April?


I see this is already done for May, so I switched to April.

UPD. Oh, it seems that Calendar View don’t remember last month selected and defaults to current one. There is also setting to change default to First event of Last event, not to choosen month.