VLOOKUP is returning blank as 1/0/1990, rather than nothing visible

excel date formatting string-formatting vlookup
Axios_Andrew picture Axios_Andrew · Feb 26, 2015 · Viewed 20.4k times · Source

All cells are formatted for dates, when a cell is blank I would like it to return an apparently blank cell rather than 1/0/1900. Here is what I have so far however It is still returning the date instead of a blank:

= IF(ISNA(VLOOKUP($B$4,TrainingDatabase!$A$3:$S$14,3,0))=  0,"", (VLOOKUP($B$4,TrainingDatabase!$A$3:$S$14,3,0)))

Answer

pnuts picture pnuts · Feb 26, 2015

Please try formatting as: 

mm/dd/yyyy;;

Related questions

Ordering issue with date values when creating pivot tables

I have a 2-column spreadsheet which contains Dates and Sales figures as follows: When doing Right click -> Format Cells the values in the Dates column properly appear as Date (in the M/D/YYYY format). This applies to …

Read More
Count number of times a date occurs and make a graph out of it

I have a list of dates, each date in it can occur more than once. I want to count the number of times each date occurs (histogram) and display it in a graph (with the Y axis being the number …

Read More
Formula to convert date to number

I would like to know the formula to convert a date in 10/26/2013 to 41573 number as done in Excel. Like how 10/26/2013 is converted to 41573.

Read More