Manuals/calci/YEAR

Revision as of 20:47, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Syntax


Examples


'''''''  ''''

Description


 

This function gives the year corresponding to a date.


YEAR

 Let's see an example in Column1Row1

C1R1 =06/01/2008

I.e.=YEAR(C1R1) is 2008

///rly

C3R1=06/01/08

I.e.=YEAR(C3R1) is 1908


Column1 Column2 Column3 Column4
Row1 06/01/2008 2008 06/01/08 1908
Row2
Row3
Row4
Row5
Row6

 

YEAR(D)

where D is the date of the year which is to find.