• Kuu
  =CONCATENATE(YEAR(Loodud),".",TEXT(Loodud,"mm"))
  =CONCATENATE(YEAR(Created),".",TEXT(Created,"mm"))
• # Nädal
  =INT((Loodud-DATE(YEAR(Loodud),1,1)+(TEXT(WEEKDAY(DATE(YEAR(Loodud),1,1)-1),"d")))/7)
• =IF(ISBLANK([VP kood]);Nimi;[VP kood])
  =IF(ISBLANK([VP kood]);Nimi;[VP kood]&""&Nimi)

=IF( AND([Date 1],[Date 2]) , DATEDIF([Date 1],[Date 2],"D") , "" )

=IF( AND([algus],[lopuaeg]) , DATEDIF([],[lopuaeg],"D") , "" )

=TEXT([algus]+[lopuaeg],"h:mm:ss")

• SharePoint Development documentation
• .