| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wrong date in Excel 2007 built-in calendar!!!
Excel system assign the date 1900/1/1 as day 1. 1900/1/2 as day 2, etc.
I found that the Excel built-in calendar consists of a serious mistake. As year 1900 is NOT a leap year, it should NOT have the day 1900/2/29. However, I can actually find that day in the Excel built-in calendar naming it as day 60. The result is all days after 1900/2/29 are one day later than the actual day. It actually causes great problem when I have to create own VB calendar functions as all the days are wrong. Will microsoft correct this problem? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New Built in Functions 2007 | Excel Worksheet Functions | |||
| Reassign built-in shortcut keys in excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 opening wrong | Excel Discussion (Misc queries) | |||
| How to link an Excel file due date to Outlook calendar date? | New Users to Excel | |||
| Calendar Problem- What's Wrong? | Excel Discussion (Misc queries) | |||
Threaded Mode
