Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula string & date now (2000 sr-1)

    in cell A1 i would want this:

    ="Data Odierna" & format(dateNow),gg/mm/aaaa

    sintiax please

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formula string & date now (2000 sr-1)

    Enter the formula
    <code>
    =TODAY()
    </code>
    in cell A1. In Italian, it is
    <code>
    =OGGI()
    </code>
    With A1 still selected, select Format | Cells...
    Select the Custom category.
    Enter the following custom format in the Type box:
    <code>
    "Data Odiema "gg/mm/aaaa
    </code>
    Click OK.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formula string & date now (2000 sr-1)

    Alternatively, use this formula:
    <code>
    ="Data Odiema "&TEXT(TODAY(),"dd/mm/yyyy")
    </code>
    In Italian:
    <code>
    ="Data Odiema "&TESTO(OGGI();"gg/mm/aaaa")</code>

  4. #4
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula string & date now (2000 sr-1)

    PERFECT!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •