Not displaying dates before 1900

[Patcheen]

im trying to get dates Before 1900 to display the dates that are meeting the criteria. but as its before 1900 it dont display, but if its 1900 onwards it has no problem displaying.

all help appreicated.


hope the pic helps.

 

[alansidman]

How to Work with Dates Before 1900 in Excel - ExcelUser.com

If you work with dates prior to 1900, Excel offers little direct help. However, some Excel formulas and a free macro can provide much of the help you need.

exceluser.com

 

[Joe4]

See here: Deal With Dates Before 1900

 

[Scott Huish]

There is also an old add-in, which I just tested and it still works, it's called XDATE. Run the EXE file and then load the add-in from the directory that it put the file in.

It's still available from the Internet Archive:
Extended Date Functions

Book1
	K	L	M
6	OLD DATE	MODERN DATE	DAY DIFFERENCE
7	10/18/1800	10/18/1967	60995
Sheet1

Cell Formulas
Range	Formula
K7	K7	=xdate(1800,10,18)
M7	M7	=XDATEDIF(L7,K7)

 

[Patcheen]

Thank you all for the advice and help - sorted thank you