Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates in VBA
The dates being returned in my formulas are 4 years and 1 day later. Even
just with the Now function. Why? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates in VBA
On Fri, 27 Oct 2006 13:09:01 -0700, wienmichael
wrote: The dates being returned in my formulas are 4 years and 1 day later. Even just with the Now function. Why? In VBA as in the Subject?? Please post examples. If you mean in your worksheet, go to Tools/Options/Calculations/Workbook Options and DEselect 1904 Date system. --ron |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates in VBA
Thanks for the help.
"Ron Rosenfeld" wrote: On Fri, 27 Oct 2006 13:09:01 -0700, wienmichael wrote: The dates being returned in my formulas are 4 years and 1 day later. Even just with the Now function. Why? In VBA as in the Subject?? Please post examples. If you mean in your worksheet, go to Tools/Options/Calculations/Workbook Options and DEselect 1904 Date system. --ron |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates in VBA
Check out the Date System you are using in ToolsOptionsCalculation.
Sounds like the 1904 system is checked. Uncheck it. Your dates will not change so you will have to subtract 1462 from each. Enter 1462 in an unused cell. Copy then select your dates and Paste SpecialSubtractOKEsc. Re-format the cells to Date as the above operation will change to Number. Gord Dibben MS Excel MVP On Fri, 27 Oct 2006 13:09:01 -0700, wienmichael wrote: The dates being returned in my formulas are 4 years and 1 day later. Even just with the Now function. Why? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identifying unique dates in a row of cells containing dates... | Excel Discussion (Misc queries) | |||
Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
Dates and Intervals | Excel Worksheet Functions | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) |