+ Reply to Thread
Results 1 to 11 of 11

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

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    02-25-2010
    Location
    Boston
    MS-Off Ver
    Excel 2007
    Posts
    174

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

    =If(E3 = "00/01/1900", "", E3)

    If that does not work you need to check the cell value that is coming back as 00/01/1900 and put that in the formula.

    so,

    =If(E3 = 0, "", E3)

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

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

    DP978

    Many thanks that worked with the zero option
    Thanks

+ Reply to Thread

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