Differences

This shows you the differences between two versions of the page.

Link to this comparison view

appwiki:excel [2016/10/20 01:17] (current)
Line 1: Line 1:
 +====== Excel Text Generating Format ======
 +  * text cell combine: <​code>​="​preText"&​A1&​B1&​C1&"​endText"</​code>​
 +
 +====== Excel formulas======
 +  * Date minus Date gets days (A1 as fixed date; A2 as date to compare)<​code>​=DATEDIF(A2,​$A$1,"​d"​)</​code>​
 +  * today'​s date<​code>​=TODAY()</​code>​
 +
 +
 +====== Excel shortcuts ======
 +
 +Data insert
 +^ctrl+; | insert date|
 +^ctrl+shift+;​ | insert time |
 +
 +====== Excel Data Creation ======
 +
 +===== excel to xml =====
 +