Results 1 to 6 of 6

How to leave Date formula cell blank until date entry??

Threaded View

  1. #1
    Registered User
    Join Date
    03-05-2011
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Question How to leave Date formula cell blank until date entry??

    From limited experience I know that excel calculates dates via serial numbers.

    I have formulas to add a number of days to a cell containing an entered date and display the resulting new date (ie. 03/01/2011 (c34)+11 = 03/12/2011)

    I am seeking to leave resulting formula cell blank until a date is entered in the input cell. Currently when the input cell is empty the formula cell obviously displays 1/11/1900 using the above example.

    What conditional format would achieve leaving the formula cell blank until date data in entered into the source cell?

    Hopefully a simpler question for your experience level than mine.
    Last edited by NewbieDateFormatter; 03-16-2011 at 01:10 AM.

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