Results 1 to 5 of 5

Date Stamp for True Value

Threaded View

  1. #1
    Registered User
    Join Date
    05-12-2020
    Location
    Mechanicsburg, PA
    MS-Off Ver
    2016
    Posts
    21

    Date Stamp for True Value

    =IF(E2=TRUE,IF(AND(ISNUMBER(F2),F2>0),F2,TODAY()),"")

    This formula was working; however, now I receive the following error:

    "There are one or more circular references where a formula refers to its own cell either directly or indirectly. This might cause them to calculate incorrectly. Try removing or changing these references, or moving the formulas to different cells."

    Essentially, I want the date cell D was checked to populate cell F with the date is was checked.

    Any help is greatly appreciated.
    Attached Files Attached Files
    Last edited by SeaLawyer; 08-25-2021 at 11:35 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 05-24-2021, 11:24 AM
  2. Replies: 1
    Last Post: 05-24-2021, 11:24 AM
  3. Replies: 6
    Last Post: 02-25-2013, 03:16 AM
  4. Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  5. Cross reference using "isnumber" & "match"
    By dagindi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2010, 06:09 PM
  6. Replies: 7
    Last Post: 05-13-2006, 05:02 PM
  7. [SOLVED] IF(VLOOKUP("MYDATA", MYNAME, 4) = 0, "TRUE", "FALSE")
    By Souris in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2005, 01:05 AM

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