appwiki:excel

Excel Text Generating Format

  • text cell combine:
    ="preText"&A1&B1&C1&"endText"

Excel formulas

  • Date minus Date gets days (A1 as fixed date; A2 as date to compare)
    =DATEDIF(A2,$A$1,"d")
  • today's date
    =TODAY()

Excel shortcuts

Data insert

ctrl+; insert date
ctrl+shift+; insert time

Excel Data Creation

  • appwiki/excel.txt
  • Last modified: 2021/08/28 08:26
  • by ying