The correct one is showing the actual dates that appear in the column that are generally Friday of each week but some may be Wednesday or Thursday of a given week. May 20-October 28, 1900 St. Louis, Missouri, USA July 1-November 23, 1904 London, England April 27-October 31, 1908; Stockholm, Sweden May 5-July 22, 1912 Berlin, Germany CANCELLED Antwerp, Belgium April 20-September 12, 1920 Paris, France Otherwise, I was getting 1900-01-01 00:00:00.000. Find answers to Date formula coming back as 1/0/1900 how do I make it blank. It defaults to 0. text format 0 as a date and you get 1/0/1900 as all dates are a serial number starting with 1 = 1/1/1900, thus 0 is a made up date of 1/0/1900 By default, Excel workbooks use the 1900 date system. Published: 08 Mar 2013 Last Modified Date: 02 Jan 2019 Issue After you convert a year field, which Tableau recognizes as a measure, to a Date data type, all date fields have the year 1905. The 2029 Rule. Environment. So 42370 is the number of days between the 01/01/1900 and 01/01/2016. So I still get a date for the populated records and remove the null values. I have a column "B" that is pulling a date from a different sheet, it is a Date value, so it has a formula in every cell in "B". How to Make Dates Show Up on the Horizontal Axis in a Chart in Excel. So by casting as date I drop the time. "text" <> number. Then casting the varchar allows for the use of the isnull function. All Dates Show up as 1905. – Elvis Candelaria Nov 17 '15 at 17:31 I have two different charts that are using the same column for the dates. In Excel, a date is the number of days since 01/01/1900 (which is the first date in Excel). As @sandy666 points out, you are returning text not a date, unless you use the DATE() function. The kicker is that I cannot figure out why flow is importing the data from the spreadsheet as plain numbers instead of as dates even though the cells themselves are formatted as dates for example the date 06/18/12 is being read in as 41078, … For example, entering dates along the x-axis gives your clients a view of your sales over time. Tableau Desktop; Excel; Resolution. When you see 1/1/1900 in a Date cell that usually means an invalid value has been entered. After you create a chart based on your worksheet data, Excel enables you to edit the labels on the horizontal axis. By default, Excel determines the century by using a cutoff year of 2029, which results in the following behavior: Dates in the inclusive range from January 1, 1900 (1/1/1900) to December 31, 9999 (12/31/9999) are valid. Dates can be displayed in different ways using the following 2 options (available in the Number Format dropdown in the main menu): Short Date; Long Date The first supported day is January 1, 1900. If your doing a calculation, and the result will not be a Date, then perhaps the cell should not be formatted as a Date cell? Here is another way of doing the same thing, but this will display a Zero in the formula bar not 01/00/1900: Hello! Date format. One works perfect and the other one is displaying the dates as 1/1/1900, 1/2/1900, etc. I'm a fairly new flow user here and I have a flow which needs to extract dates from an excel spreadsheet and email them out.