Correctly Formattting Dates in Excel
ฝัง
- เผยแพร่เมื่อ 26 ส.ค. 2024
- If you regularly import data into Excel, you'll often find your dates are incorrectly formatted as text, which results in you not being able to perform date calculations and formulas.
In this tutorial we show you how to convert incorrect text date entries into correct Excel dates quickly and efficiently.
This helped me a lot! Thanks so much
Very Helping Video. thank you.
SAVED MY LIFE THANKS!
Hi !
I've to find days between two date. below mention dates are Not in proper date format as its downloaded as CSV save as excel.
My dates are like 21-09-2017 & 25-09-2017(i.e DD-MM-YY). days difference =4.
pls, Help me how i'll get it easily.
You can just replace the periods (.) with dash (-) or forward slash (/) and you will get date format.
But its not work if i input in the format date/month/year