1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL.MI

  • formula of Inserting a Date in a cell without updating the date

    From Rabbi Moshe Hadad@21:1/5 to All on Wed May 5 03:03:34 2021
    I want to add a Date in a cell based on another cell,
    For example:
    =if(D2="","Empty",TODAY()),

    But i don't want that "Today" will be update. It just need to stamp the Today date without keep updating.

    Any idea?

    Thank you

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Claus Busch@21:1/5 to All on Thu May 6 13:40:15 2021
    Hi,

    Am Wed, 5 May 2021 03:03:34 -0700 (PDT) schrieb Rabbi Moshe Hadad:

    I want to add a Date in a cell based on another cell,
    For example:
    =if(D2="","Empty",TODAY()),

    But i don't want that "Today" will be update. It just need to stamp the Today date without keep updating.

    that is not possibe with a formula.
    You must write the date with the shortcut or with VBA.


    Regards
    Claus B.
    --
    Windows10
    Microsoft 365 for business

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)