View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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,