Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Nov 2005
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adding 2014 to a date range causes errors in spreadsheet

    I have a rather complex spreadsheet that we use to calculate sick days that was created by someone who left the company a long time ago

    Now at the top of the sheet I have data validation drop down list. I added 2014 in the range and now hundreds of calls have the #N/A ERROR

    When I switch back to 2013 all the calls have data

    I have tried putting 2014 in all the data validation range and still errors

    The error cells refer to cell b2 which = =(C2&" "&D2). Column c has a drop down of months and D has the years

    I am totally baffled

    Sample attached
    Attached Files Attached Files
    Last edited by greenoak; 2014-02-11 at 09:39.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I would advise attaching a sample with any personal and proprietary information removed.

    Steve

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi greenoak

    On your sheet [input], you had an incorrect formula in cell [F28], which I fixed.
    This wasn't the cause of your problem though.
    The way I fixed your problem was to copy the cells in range [EC41:EZ41] to location [FA41:FX41]
    Then, selecting range [FA41:FX41] I used Ctrl-H (for Find and Replace) and replaced 2013 with 2014 for all cells in the highlighted selected range.

    That seemed to do the trick.

    see attached

    zeddy
    Attached Files Attached Files

  4. #4
    New Lounger
    Join Date
    Nov 2005
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Many many thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •