+ Reply to Thread
Results 1 to 2 of 2

Working with dates and formulas

  1. #1
    Registered User
    Join Date
    San Jose, CA
    MS-Off Ver
    Excel 2010

    Working with dates and formulas

    Hello everyone. I need help with the following:

    I have two columns:
    Column A is for entry of any date in cell C6
    Column B contains a formula (i.e., =C6+10) to calculate a due date 10 days from the date in Column A

    The problem is, anytime I erase the date in Column A, or leave it blank, a default date appears in Column B (i.e., 1/10/00).
    Is there a way to leave Column A blank and at the same time have Column B blank as well?

  2. #2
    Valued Forum Contributor
    Join Date
    Sydney, Australia
    MS-Off Ver
    2013 64bit

    Re: Working with dates and formulas

    The issue is that the result after you blank out column A is you end up with 10 in column B, and 1/10/00 is the 10th day of year zero.

    Change your formula in column B to be as follows

    Please Login or Register  to view this content.
    My approach to providing help is to help you to help yourself. So my answers won't always solve your problem, but hopefully you can learn enough to solve the problem yourself and be more self sufficient for the experience.

+ 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. Excel formulas calculate working hours bet two dates with criteria
    By breadwinner in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-02-2013, 01:28 AM
  2. Replies: 9
    Last Post: 03-08-2013, 11:50 AM
  3. Help Working Out Relative Dates and Non Working Days
    By leungf in forum Excel General
    Replies: 0
    Last Post: 08-07-2012, 12:06 PM
  4. Formulas not working with double digit dates
    By ckk403 in forum Excel General
    Replies: 13
    Last Post: 12-30-2010, 10:36 AM
  5. Replies: 7
    Last Post: 01-16-2009, 05:04 AM


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