Setting format for imported data from Sharepoint

Occasional Visitor

I have data being imported from SharePoint, and like a few other posts it is pulling over in text format.

In my excel sheet I am using project dates from the imported and IF formulas to provide a value however the forumals aren't recognising the dates as dates, showing values in " " when I evaluate the formula.  How do I set the text in the SharePoint data to be viewed as a date without the need to use text to columns manually each time someone opens the document which would be a huge task. 


Any help would be greatly appreciated - even if I need to create a separate excel sheet first and pull from there instead.



Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies