Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I Modify Julian calendar restriction of 1900
Am working on family tree with many born dates prior to 1900 and death dates
after 1900. Can't write formula to calculate age because of pre-1900 birthdate. Excel doesn't record a Julian number on the dates earlier than 1900. Is there a workaround? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I Modify Julian calendar restriction of 1900
SAPOMAN wrote:
Am working on family tree with many born dates prior to 1900 and death dates after 1900. Can't write formula to calculate age because of pre-1900 birthdate. Excel doesn't record a Julian number on the dates earlier than 1900. Is there a workaround? A little searching yielded this: http://www.j-walk.com/ss/excel/files/xdate.htm |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I Modify Julian calendar restriction of 1900
http://j-walk.com/ss/excel/files/xdate.htm
-- Gary''s Student - gsnu200909 "SAPOMAN" wrote: Am working on family tree with many born dates prior to 1900 and death dates after 1900. Can't write formula to calculate age because of pre-1900 birthdate. Excel doesn't record a Julian number on the dates earlier than 1900. Is there a workaround? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import excel 2003 dates & notes to Julian calendar format? | Excel Worksheet Functions | |||
Will the 2008 Julian Calendar be updated for 2009 and beyond? | Excel Discussion (Misc queries) | |||
Dates from Julian calendar | Excel Discussion (Misc queries) | |||
Julian Calendar | Excel Discussion (Misc queries) | |||
how to convert julian date to regular calendar date | Excel Worksheet Functions |