Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
147
Views
Topic starter
Hi,
I have 2 columns of dates. My manager wants it to be written like this - 01.03.2023 even though it's not correct
Now he has to perform a calculation - how many days are there between 2 dates?
I would love to have a function that knows how to calculate and convert the points in / and calculate thanks!!
Posted : 01/04/2024 6:48 am
The easiest way to convert 24.05.2029 in A2 to 24/05/2019 would be to use SUBSTITUTE
=DATEVALUE(SUBSTITUTE(A2,".","/"))
Do the same for the end date in B2. Now put both into one formula to calculate the days between them.
=DATEVALUE(SUBSTITUTE(B2,".","/"))-DATEVALUE(SUBSTITUTE(A2,".","/"))
Posted : 02/04/2024 1:29 am
