, Word Excel, (, 05/18/1983 21.03.2012), Excel ( 01.01.1900 Excel 2013) , ( , , Excel), , ( 01/01/1900 - 1, 05/18/1983 - 30454 (... 00/01/1900 0!)).
, :
{= {DATE \@ "YYYY"} - my_year - 1*{=OR({={DATE \@ "MM"} < my_month};{=AND({={DATE \@ "MM"} = my_month};{={ DATE \@ "dd"} < my_day})})} \* MERGEFORMAT}
:
- {} Word ( ) CTRL + F9.
- 'my_year', 'my_month' () 'my_day':
- 4 ( , ), .
- , : " my_year" , , my_month, , , my_day, .
MERGEFORMAT .
, , Word:
- {} "Toggle Field Codes", (texte ) , ( ).
- , , " ".
- , , ( , ), "Toggle Field Codes" ( , void, , ).
18.05.1983 ( 1 , 01/01 18-, ):
{= {DATE \@ "YYYY"} - 1983 - 1*{=OR({={DATE \@ "MM"} < 05};{=AND({={DATE \@ "MM"} = 05};{={ DATE \@ "dd"} < 18})})} \* MERGEFORMAT}