Category

Difference between revisions of "Office 2010"

From Blue-IT.org Wiki

(Created page with "== Excel == === Kalenderwoche === ActiveCell.FormulaR1C1 = _ "=CONCATENATE(""0"",TRUNC((RC[-25]-DATE(YEAR(RC[-25]+4-WEEKDAY(RC[-25],2)),1,-9+WEEKDAY(RC[-25],3)))/7),"" / "",...")
 
(Kalenderwoche)
 
Line 1: Line 1:
 
== Excel ==
 
== Excel ==
 
=== Kalenderwoche ===
 
 
ActiveCell.FormulaR1C1 = _
 
"=CONCATENATE(""0"",TRUNC((RC[-25]-DATE(YEAR(RC[-25]+4-WEEKDAY(RC[-25],2)),1,-9+WEEKDAY(RC[-25],3)))/7),"" / "",YEAR(RC[-25]))"
 

Latest revision as of 09:31, 9 July 2014

Excel

Pages in category "Office 2010"

The following 2 pages are in this category, out of 2 total.