+ Reply to Thread
Results 1 to 5 of 5

Fixing Date Error -

Hybrid View

  1. 01-07-2013, 10:30 AM #1
    Kevin UK
    Kevin UK is offline
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Fixing Date Error -

    Hi JCL622

    Copy the formula down in A171
    Attached Files Attached Files
    Last edited by Kevin UK; 01-07-2013 at 10:32 AM.
    Regards Kevin


    Merged Cells (They are the work of the devil!!!)
    Reply With QuoteRegister To Reply
  2. 01-07-2013, 10:49 AM #2
    JCL622
    JCL622 is offline
    Registered User
    Join Date
    04-24-2012
    Location
    New York, New York
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Fixing Date Error -

    What did I have to do differently? I noticed you took out all the weekend date breaks.

    Also will the formula break if I change the dates? I would like to change H5 to 11/28/2013 and H6 to 12/25/2013
    Reply With QuoteRegister To Reply
  3. 01-07-2013, 10:54 AM #3
    JCL622
    JCL622 is offline
    Registered User
    Join Date
    04-24-2012
    Location
    New York, New York
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Fixing Date Error -

    Nevermind I think I realized what I did wrong..wow..

    I set up my dates wrong and the program got confused.

    Ok! new question - So for A173 I did - =+A171+3, but for A174 I will do A173+1. Is there a way to change that all the way down the column? or do I have to manually change each one?
    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)

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