+ Reply to Thread
Results 1 to 3 of 3

Cond Format Calculation Returns Different Values On Different Computers

  1. #1
    Registered User
    Join Date
    06-29-2011
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2007
    Posts
    3

    Cond Format Calculation Returns Different Values On Different Computers

    Greetings -

    I have the following calculation in conditional formatting for the purpose of highlighting the most recently completed week number.

    =(WEEKNUM(TODAY(),1))+12

    On one computer, running 2010 Excel in Windows XP, this highlights Week 16.

    On another computer, running 2007 Excel in Windows 7, this highlights Week 17.

    Any ideas as to why this is happening and what can be done about would be greatly appreciated.

    Thanks,

    Aaron

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,659

    Re: Cond Format Calculation Returns Different Values On Different Computers

    You can check TODAY() with the two computer to find out which one must to be reset date setting.
    Quang PT

  3. #3
    Registered User
    Join Date
    06-29-2011
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Cond Format Calculation Returns Different Values On Different Computers

    =TODAY() returns the same date on both computers...

    - Aaron

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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