Difference between revisions of "Excel"
From Blue-IT.org Wiki
Line 4: | Line 4: | ||
ActiveCell.FormulaR1C1 = _ | 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]))" | "=CONCATENATE(""0"",TRUNC((RC[-25]-DATE(YEAR(RC[-25]+4-WEEKDAY(RC[-25],2)),1,-9+WEEKDAY(RC[-25],3)))/7),"" / "",YEAR(RC[-25]))" | ||
+ | |||
+ | === Open Street Map Hyperlink in Excel === | ||
+ | |||
+ | Koordinates in E10 and F10 like: "48,9283475" (with comma"). | ||
+ | |||
+ | =HYPERLINK("http://www.osm.org/?mlat="&WECHSELN(E10;",";".")&"&mlon="&WECHSELN(F10;",";".")&" & zoom="&E10&"#map=16/"&WECHSELN(RUNDEN(E10;5);",";".")&"/"&WECHSELN(RUNDEN(F10;5);",";".");"Stelle bei OpenStreetMap") | ||
[[Category:Excel]] | [[Category:Excel]] | ||
[[Category:Office 2010]] | [[Category:Office 2010]] |
Revision as of 10:01, 9 July 2014
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]))"
Open Street Map Hyperlink in Excel
Koordinates in E10 and F10 like: "48,9283475" (with comma").
=HYPERLINK("http://www.osm.org/?mlat="&WECHSELN(E10;",";".")&"&mlon="&WECHSELN(F10;",";".")&" & zoom="&E10&"#map=16/"&WECHSELN(RUNDEN(E10;5);",";".")&"/"&WECHSELN(RUNDEN(F10;5);",";".");"Stelle bei OpenStreetMap")