DATEVALUE and VALUE function is not working

Hi @Dheeraj Singh, 

Thank you for posting your question in the Microsoft Q&A forum.  

Based on my understanding, your issue is that the DATEVALUE and VALUE functions in Excel are not working with a date string formatted as "03.03.2025". Could you please confirm if my understanding is correct? 

If so, the reason is that these functions only recognize Excel's standard date formats, and the period/dot (.) is not a default date separator. Therefore, Excel treats the string "03.03.2025" as regular text. 

If in this case, you can consider use the SUBSTITUTE function in combination with DATEVALUE to replace the period with a forward slash. After applying this formula, the cell will display a numeric value. You just need to format that cell as a date to see the correct date. 

If these options do not match what you are looking for, please help me provide more details about your request so that I can better help you with the next steps.

Looking forward to your response!   

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.