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 |