Stephen Larivee

Posts: n/a

Date functions for dates pre-1900

I am trying to use a function that will tell me the day of the week for a
date such as 6/14/1851. It works fine when I enter a date from 1900 or
later but not for 1851 or something else in the 19C. Is there a way of
doing it in Excel???

Thanks

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
How do I create a schedule from a list of dates ?	Gavin Morris	Charts and Charting in Excel	2	October 28th 10 04:08 PM
Date functions	Dale	Excel Discussion (Misc queries)	5	April 10th 05 01:45 PM
How do I extract a date as text not the 1900 reference number	Adam	Excel Discussion (Misc queries)	3	March 23rd 05 05:04 PM
How do I enter a date before 1900 in excel?	woodrat	Excel Worksheet Functions	3	January 14th 05 02:39 PM
How do I enter a date before 1900 in excel?	woodrat	Excel Worksheet Functions	1	January 14th 05 10:37 AM

All times are GMT +1. The time now is 11:53 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us