Results 1 to 9 of 9

Simple Date Query 00/01/1900

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-03-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    109

    Simple Date Query 00/01/1900

    Hi,

    Prob a real simple one, but im struggling a bit.

    I have a very simple vLOOKUP running between two sheets. I just want to pull the date from sheet 2. But there isnt a date in one of the cells, so it returns thedate value 00/01/1900. I would like it to either say 0 or be completly blank. Ideally blank though.

    From the report I run and input, if the site has not been brought on air there will not be a date, so I cant just manually put the 0 in otherwise that would defeat the object

    Many Thanks in advanced
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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