Thread: Dates in VBA
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
wienmichael wienmichael is offline
external usenet poster
 
Posts: 11
Default 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