How can i input a date/year older than 1900, eg: 1 Jan 1822 ?
 

Is there a plugin to support date entry older than 1900 ?
How do we support family trees ?
thanks,

How can i input a date/year older than 1900, eg: 1 Jan 1822 ?
 

The simple solution is just to put a single quote in front of the date to
make it a string. You won't be able to do math functions using this
solution. the problem gets complicated because of adjustments in the
calendar depending how far back you are going. Back in Roman times they went
from 9 months to, 10 months, to 12 months. In George Washington times they
made a bick change in the calendar because the seasons and the months were
wrong because they weren't adding a leap day every four years.

The Jewish calendar is based on the lunar year and adds an extra month to
make corrections. This year happens to be a 13 month year in the jewish
calendar.

"paulsouthern" wrote:

Is there a plugin to support date entry older than 1900 ?
How do we support family trees ?
thanks,

How can i input a date/year older than 1900, eg: 1 Jan 1822 ?
 

See this:

http://spreadsheetpage.com/index.php...nctions_xdate/

--
Biff
Microsoft Excel MVP


"Joel" wrote in message
...
The simple solution is just to put a single quote in front of the date to
make it a string. You won't be able to do math functions using this
solution. the problem gets complicated because of adjustments in the
calendar depending how far back you are going. Back in Roman times they
went
from 9 months to, 10 months, to 12 months. In George Washington times
they
made a bick change in the calendar because the seasons and the months were
wrong because they weren't adding a leap day every four years.

The Jewish calendar is based on the lunar year and adds an extra month to
make corrections. This year happens to be a 13 month year in the jewish
calendar.

"paulsouthern" wrote:

Is there a plugin to support date entry older than 1900 ?
How do we support family trees ?
thanks,

How can i input a date/year older than 1900, eg: 1 Jan 1822 ?
 

Hi,

John Walkenbach's site has some useful stuff

http://spreadsheetpage.com/index.php...ate_functions/

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"paulsouthern" wrote:

Is there a plugin to support date entry older than 1900 ?
How do we support family trees ?
thanks,