Results 1 to 11 of 11

Produce a blank cell if date is = 00/01/1900

Threaded View

  1. #1
    Registered User
    Join Date
    01-13-2010
    Location
    Erskine
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    34

    Produce a blank cell if date is = 00/01/1900

    I have a column of data that requires the cell to be blank if the value is 00/01/1900.
    The data is linked to another cell.
    IE: cell E3 is linked to cell $D$3
    The cell is formatted for dates in the format shown.
    Any Help please.
    Last edited by Butehawk; 05-12-2010 at 05:18 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