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.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
Larina23 pe Simpatie
 | Femeie
24 ani
Timis
cauta Barbat
28 - 80 ani |
|
TonyTzu
Moderator
 Inregistrat: acum 12 ani
Postari: 252
|
|
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).
|
|
| pus acum 9 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 18 ani
Postari: 2241
|
|
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
_______________________________________
|
|
| pus acum 5 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
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
Modificat de TRaP (acum 4 ani)
|
|
| pus acum 4 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
Source:
=TEXT(A2;"dd.mm.yyyy")
|
|
| pus acum 1 an |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
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.
|
|
| pus acum 1 an |
|