+ Reply to Thread
Results 1 to 2 of 2

static date

  1. #1
    Registered User
    Join Date
    12-24-2006
    Posts
    32

    static date

    Hi All,
    Has anyone figured out how to place a static date/time by using a formula. the Dynamic formula would be =if(a1<>"",today(),"")
    I would like to be static so that once it's inputted it does not change, I know that I can change it once I've input it, but was wondering if there's another way.
    Thank you
    James
    Last edited by James_SF; 08-19-2020 at 12:05 PM. Reason: Solution founded

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,684

    Re: static date

    you can use a timestamp formula, have a read here, explains how to setup

    https://howtoexcelatexcel.com/excel-...with-formulas/
    https://chandoo.org/wp/timestamps-excel-formula-help/
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. instead of static date a insert field for date
    By Framboosje in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2019, 11:27 AM
  2. Formula for certain date to appear based on a static today's date
    By jasminew in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-12-2017, 05:58 AM
  3. [SOLVED] Insert static date automatically on pasting large amount of date
    By Toro- in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-21-2016, 08:11 AM
  4. Static date?
    By BMBme in forum Excel General
    Replies: 14
    Last Post: 11-23-2015, 12:16 AM
  5. Highlight Rows Based on Date Range Using Static Date and Current Date
    By SaraStravers in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-23-2015, 07:38 PM
  6. Static date
    By Pedro1803 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2011, 12:41 PM
  7. DATE STATIC
    By Shaggy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-21-2006, 09:20 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1