Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie:
crazygirl la Simpatie.ro
 | Femeie
24 ani
Buzau
cauta Barbat
26 - 80 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
|
|
If you want to convert all dates from a column to text, you can use the following formula.
Say you have 1000 dates in column A, from A1-A1000
In A1 you have: 15.03.1972
In B1 write =TEXT(A1;"dd-mm-yyyy")
The date in B1 will be 15-03-1972, value that can be copied anywhere as it is, it won't be converted automatically to date or to the number of days since year 1900 (which is the date serial number).
|
|
| |
|
| #2 |
|
|
Convert serial number to date
In A1 you have: 26373
In B1 you write: =TEXT(I8;"dd.mm.yyyy")
The date in B1 will be 15.03.1972
_______________________________________
|
|
| |
|
| #3 |
TRaPModerator
Postari: 960
|
|
Difference between 1 date and a number of days => a date - dates are not stored in cells, but in the formula itself
=TEXT(DATEVALUE("22.01.2021")-90;"dd.mm.yyyy")
The result is 24.10.2020
Difference between 2 dates - dates are not stored in cells, but in the formula itself
=DATEVALUE("22.01.2021")-DATEVALUE("24.10.2020")
The result is 90
|
|
| |
|
| #4 |
TRaPModerator
Postari: 960
|
|
|
| |
|
| #5 |
TRaPModerator
Postari: 960
|
|
If A2 contains the date in date format, one way to obtain reversed would be so say for example in cell A3:
=A2
And then set the formatting of A3 to number.
|
|
| |
|
