Hello @Parvathy, Thank you very much for your response.
I have to admit I feel pretty embarrassed 
, Yesterday was a complicated day and I guess I still forget the basics and check the properties of the activities very carefully. 
I guess I have no trouble consulting the forum every time I need something.
Yet with the answers on the topic I started testing the different configurations available mostly for the Excel activities (That worked better for my case), and I reached interesting outputs that might be useful for you and the community to see. One of them being that even when I checked the Preserve Format property from the Read Range Workbook Activity still the date values were modified… These are the different outputs.
Date Format from Original File:
24/08/2023
Preserve Format (False)
08/24/2023 00:00:00
Preserve Format (True)
8/24/2023
Finally I realized that is better to use the excel activities for this kind of cases.
Thank you once again.