Posted to microsoft.public.excel.worksheet.functions

SAPOMAN

external usenet poster

Posts: 1

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
import excel 2003 dates & notes to Julian calendar format?	Cynthia N	Excel Worksheet Functions	2	May 26th 09 03:39 PM
Will the 2008 Julian Calendar be updated for 2009 and beyond?	Margie Caner	Excel Discussion (Misc queries)	0	March 18th 08 05:22 PM
Dates from Julian calendar	y_not	Excel Discussion (Misc queries)	1	October 24th 05 06:36 PM
Julian Calendar	Pete	Excel Discussion (Misc queries)	1	May 15th 05 05:12 PM
how to convert julian date to regular calendar date	Ron	Excel Worksheet Functions	5	May 5th 05 11:05 PM

All times are GMT +1. The time now is 07:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us