Results 1 to 6 of 6

Display 'Date' cell as blank instead of default year 1900

Threaded View

  1. #1
    Registered User
    Join Date
    11-19-2009
    Location
    Wrexham, Wales
    MS-Off Ver
    Excel 2003
    Posts
    8

    Display 'Date' cell as blank instead of default year 1900

    Three columns.
    A - Date last checked
    B - Due Date
    C - Actual Date checked

    Currently column B is formatted to Date and simply has =A+84 and will display a date 3 months in future.. Great..

    However if there is no date in column A, then column B displays a default 1900 date.. Is there a way of making this blank if there is no date in col A?

    Thanks in advance.....
    Last edited by charger100; 11-19-2009 at 05:22 PM.

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