| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I can't get Excel to caluate dates in the 1800's. #VALUE!
Look he
http://www.j-walk.com/ss/excel/files/xdate.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "KenB" wrote in message ... |I am using a date 3-9-1857. I want to add a number of days to that date and | see what it is. I can do this with dates after 1-1-1900, but not before | that. I just get #VALUE! in that column. Is there anyway I can work with | dates before 1900 ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel not recognizing dates as dates | Excel Discussion (Misc queries) | |||
| how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
| Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
| How do I get the dates on an excel chart to stay as dates instead. | Charts and Charting in Excel | |||
| How do I convert the date from 1900's to 1800's? | Excel Discussion (Misc queries) | |||
Threaded Mode
