how to create dates before 1900

[Guest]

as time values for a graph, how can I get these accepted as dates to plot
data for a time series for, let's say, housing prices between 1750 and 2005?

 

[Harlan Grove]

Pieter wrote...

as time values for a graph, how can I get these accepted as dates to plot
data for a time series for, let's say, housing prices between 1750 and

2005?

Unless you're plotting daily house prices, you don't need to use dates.
So don't. Enter years and housing prices as simple numbers, and plot as
X-Y scatter charts. If you need to include month names, enter year and
month as text and housing prices as simple numbers, and plot as a line
chart.

It's possible to manipulate date *strings* prior to 1900, but they'll
*always* be text, so they'll screw up X-Y charts but not line charts.

 

[Bob Phillips]

In the UK, you need daily prices

Pieter wrote...
2005?

Unless you're plotting daily house prices, you don't need to use dates.
So don't. Enter years and housing prices as simple numbers, and plot as
X-Y scatter charts. If you need to include month names, enter year and
month as text and housing prices as simple numbers, and plot as a line
chart.

It's possible to manipulate date *strings* prior to 1900, but they'll
*always* be text, so they'll screw up X-Y charts but not line charts.