+ Reply to Thread
Results 1 to 5 of 5

Today's date causes Circular Referece

  1. 12-08-2013, 09:50 AM #1
    kjsconv
    kjsconv is offline
    Registered User
    Join Date
    12-30-2012
    Location
    Nacogdoches, Tx
    MS-Off Ver
    Excel 2015
    Posts
    65

    Today's date causes Circular Referece

    Several places on my spread sheets I need to compare an action date to today's date.

    I use
    Please Login or Register  to view this content.
    in one cell and the fomulas to compare a date in a different cell to that cell.

    I get the message "Circular References" for the cell the the above "today()" formula.

    I do not get circular references in the cell that refer to the today cell, just the today cell.

    Anyone know why?
    Reply With QuoteRegister To Reply
  2. 12-08-2013, 09:56 AM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,669

    Re: Today's date causes Circular Referece

    Difficult to determine without seeing the spreadsheet. Suggest you upload for analysis.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 12-08-2013, 10:32 AM #3
    kjsconv
    kjsconv is offline
    Registered User
    Join Date
    12-30-2012
    Location
    Nacogdoches, Tx
    MS-Off Ver
    Excel 2015
    Posts
    65

    Re: Today's date causes Circular Referece

    OK, I removed all the personal data not used in the formulas.

    Thank You
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 12-08-2013, 12:38 PM #4
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,669

    Re: Today's date causes Circular Referece

    Opened the file and cannot reproduce the circular message. What are you doing to cause this event?
    Reply With QuoteRegister To Reply
  5. 12-08-2013, 04:57 PM #5
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Today's date causes Circular Referece

    Did a Trace Dependants on AU4 and then tried various changes to dates and other related data and couldn't produce an error.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to have =Today() Function keep today's date adn nt change tomorrow or in future
    By benitopjuarez in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-06-2023, 08:19 PM
  2. Excel 2007 : Incorrect Circular Reference with TODAY function
    By Erikmalk in forum Excel General
    Replies: 12
    Last Post: 08-23-2014, 08:44 PM
  3. condit. format: If date in cell = today, display "Today"
    By ratkins in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-14-2013, 01:33 PM
  4. [SOLVED] Excel 2007 : Incorrect Circular Reference with TODAY() function
    By qaliq in forum Excel General
    Replies: 5
    Last Post: 03-13-2012, 06:48 AM
  5. Moving to today's date and/or opening doc at today's date
    By joeljoel in forum Excel General
    Replies: 6
    Last Post: 08-08-2011, 08:32 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1