appwiki:excel

no way to compare when less than two revisions

Differences

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


—appwiki:excel [2021/08/28 08:26] (current) – created ying
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 =====
 +
  
  • appwiki/excel.txt
  • Last modified: 2021/08/28 08:26
  • by ying