| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with pasting dates - year mysteriously changes
I'm getting some strange behavior in a formula. It's a very simple formula:
=A2 In cell A2 is a date, formatted correctly as 29-Sep-03. Excel recognizes it as a date, and will perform correct calculations with it (weeknum, etc.) and will allow it to be changed to different date formats, which still display the correct 2003 date. However, when I reference the cell using the above equation, I get 29-Sep-07. Why does excel add 4 years to my date? Thank you, HB |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Problem with pasting dates - year mysteriously changes
That did the trick! Thank you so much!
HB "Roger Govier" wrote: Hi ToolsOptionsCalculation and uncheck the 1904 Date system Regards Roger Govier picklet222 wrote: I'm getting some strange behavior in a formula. It's a very simple formula: =A2 In cell A2 is a date, formatted correctly as 29-Sep-03. Excel recognizes it as a date, and will perform correct calculations with it (weeknum, etc.) and will allow it to be changed to different date formats, which still display the correct 2003 date. However, when I reference the cell using the above equation, I get 29-Sep-07. Why does excel add 4 years to my date? Thank you, HB |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Problem with pasting dates - year mysteriously changes
Hi
ToolsOptionsCalculation and uncheck the 1904 Date system Regards Roger Govier picklet222 wrote: I'm getting some strange behavior in a formula. It's a very simple formula: =A2 In cell A2 is a date, formatted correctly as 29-Sep-03. Excel recognizes it as a date, and will perform correct calculations with it (weeknum, etc.) and will allow it to be changed to different date formats, which still display the correct 2003 date. However, when I reference the cell using the above equation, I get 29-Sep-07. Why does excel add 4 years to my date? Thank you, HB |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ho to Delete "Ghost" Pivot Tables | Excel Discussion (Misc queries) | |||
| Problem with pasting | Excel Discussion (Misc queries) | |||
| How sort dates just by day/month and NOT year if all 3 given in ce | Excel Worksheet Functions | |||
| Problem with dates | Excel Worksheet Functions | |||
| How can I hide points for future dates on a Year to Date chart? | Charts and Charting in Excel | |||
Linear Mode
