Excel does not store dates as dates, but rather as numbers. There is a conversion for this, but you are much better off storing them as Text and converting them with DateValue() to read them and Text() to store them. Or you could switch the SharePoint (if you have it a very good idea for many reasons) and a date will work.
Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like. MVP (Business Applications) Visit my blog Practical Power AppsBuy me a coffee
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
6
Share
Report
All responses (
Answers (
