Translations:Faq/Calc/139/6/en

    From The Document Foundation Wiki
    • Dropdown list
      1. Select the cell or range of cells concerned and go to Data ▸ Validity
      2. On the Criteria tab, and the Allow listbox, choose Cell Range
      3. In the Source box, type TEXT(TODAY();"JJ/MM/AA")