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:
verona1991
 | Femeie
25 ani
Iasi
cauta Barbat
26 - 62 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
|
|
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:
https://learn.microsoft.com/vi-vn/offic ... -leap-year
_______________________________________
|
|
| |
|
