+ Reply to Thread
Results 1 to 7 of 7

Data not adjusting when date changes.

  1. #1
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Data not adjusting when date changes.

    Have a production report. It has two pages, one is a Summary, the other Totals. The employees enter their information on the Totals sheet and on the Summary I can select the date from a drop down and it should show me the employees information for that day only. I recently broke it I guess. I do not know where I screwed it up at but the summary doesn't change when I change the date.

    In the Date columns that looks for the matching date in my data validation box has this

    Please Login or Register  to view this content.

    I just opened an original version, one that hadn't been tampered with and was saved just for this kind of thing and it doesn't seem to work either?
    Attached Files Attached Files
    Last edited by taylorsm; 01-12-2017 at 01:00 PM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Data not adjusting when date changes.

    Change Calculate Options to "Automatic"

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Data not adjusting when date changes.

    @Taylor,

    When you have a moment would you change your location to something meaningful please. It often helps us if we need to consider regional settings and date formats.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Re: Data not adjusting when date changes.

    Disregard, duplicate post
    Last edited by taylorsm; 01-12-2017 at 01:45 PM.

  5. #5
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Re: Data not adjusting when date changes.

    What the hell! I have never changed that!

    Thank you very much.

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Data not adjusting when date changes.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  7. #7
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Re: Data not adjusting when date changes.

    sorry, normally good about doing that. Thanks again

+ 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. Macro for Date Adjusting
    By luigihikari in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-27-2012, 07:14 PM
  2. Adjusting Sum Product for Date
    By erock24 in forum Excel General
    Replies: 5
    Last Post: 02-20-2007, 12:35 PM
  3. [SOLVED] Adjusting Date Results
    By JoeKazz in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  4. [SOLVED] Adjusting Date Results
    By JoeKazz in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. [SOLVED] Adjusting Date Results
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-06-2005, 04:05 AM
  6. [SOLVED] Adjusting Date Results
    By JoeKazz in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. [SOLVED] Adjusting Date Results
    By JoeKazz in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  8. Adjusting Date Results
    By JoeKazz in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-10-2005, 03:05 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