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:
Ana Maria 25 24 ani
 | Femeie
24 ani
Bucuresti
cauta Barbat
35 - 68 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 18 ani
Postari: 2310
|
|
The following formula will check if the year is Leap or Regular:
| =IF( OR( MOD([@An];400)=0; AND( MOD([@An];4)=0; MOD([@An];100)<>0 ) ); 29; 28) |
I included the above in a formula that has as input the year and the short name of the month (eg ian, feb, mar etc.). This was done inside a Table where "An" is "Year", "Luna" is "Month" and month short names can easily be figured out using their given number in the formula below.
I obtained the following big formula:
=DATE([@An];
IFS([@Luna]="ian";1;[@Luna]="feb";2;[@Luna]="mar";3;[@Luna]="apr";4;[@Luna]="mai";5;[@Luna]="iun";6;[@Luna]="iul";7;[@Luna]="aug";8;[@Luna]="sep";9;[@Luna]="oct";10;[@Luna]="noi";11;[@Luna]="dec";12);
IFS(OR([@Luna]="ian";[@Luna]="mar";[@Luna]="mai";[@Luna]="iul";[@Luna]="aug";[@Luna]="oct";[@Luna]="dec");31;
OR([@Luna]="apr";[@Luna]="iun";[@Luna]="sep";[@Luna]="noi");30;
[@Luna]="feb";IF(OR(MOD([@An];400)=0;AND(MOD([@An];4)=0;MOD([@An];100)<>0));29;28))) |
Source:
_______________________________________
|
|
| pus acum 1 an |
|