Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can i input a date/year older than 1900, eg: 1 Jan 1822 ?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dates older than 1900 | Excel Worksheet Functions | |||
Incorrect Excel date 1900 is not a leap year 1/1/1901 < 367 | Excel Discussion (Misc queries) | |||
FORMAT A CELL TO USE MO/DATE WITH NO YEAR:,DISPLAYS 1900? | Excel Discussion (Misc queries) | |||
date year input | Excel Discussion (Misc queries) | |||
can I format dates older than 1900 | Excel Worksheet Functions |