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:
loca23
 | Femeie
23 ani
Cluj
cauta Barbat
23 - 44 ani |
|
TonyTzu
Moderator
 Inregistrat: acum 12 ani
Postari: 252
|
|
Adding or subtracting days
A1 = 09.12.2015
Add 5 days to date
B1 = A1+5
Subtract 3 days from date
B2 = A1-3
Adding or subtracting months
A1 = 09.12.2015
Add 5 months to date
B2 = EDATE(A1;5)
Subtract 16 months from date
B2 = EDATE(A1;-16)
Adding or subtracting years
A1 = 09.12.2015 B1 = 1
A2 = 09.12.2015 B2 = -9
Adding 1 year to date
C1 = DATE(YEAR(A1)+B1;MONTH(A1);DAY(A1))
Subtracting 9 years from date
C2 = DATE(YEAR(A2)+B2;MONTH(A2);DAY(A2))
If it doesn't work, remember to replace ; with , in formulas.
Source:
|
|
| pus acum 8 ani |
|