Dates In VBA

's Computer Specifications

All of my dates in my user defined functions are being returned as the date
plus 4 years and 1 day. Even the Now function returns todays date plus this
time. why?

's Computer Specifications

Hi wienmichael

See

Tools>Options..Calculation

See the checkbox in 1904 date system

--
Regards Ron de Bruin
http://www.rondebruin.nl

"wienmichael" <(E-Mail Removed)> wrote in message news:B56F229A-C1F2-4C51-B7E5-(E-Mail Removed)...
> All of my dates in my user defined functions are being returned as the date
> plus 4 years and 1 day. Even the Now function returns todays date plus this
> time. why?

's Computer Specifications

Thanks for the help

"Ron de Bruin" wrote:

> Hi wienmichael
>
> See
>
> Tools>Options..Calculation
>
> See the checkbox in 1904 date system
>
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "wienmichael" <(E-Mail Removed)> wrote in message news:B56F229A-C1F2-4C51-B7E5-(E-Mail Removed)...
> > All of my dates in my user defined functions are being returned as the date
> > plus 4 years and 1 day. Even the Now function returns todays date plus this
> > time. why?
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting dates to current dates to find out the evaluation date	Donica24	Microsoft Access Queries	1	26th Jan 2010 04:38 PM
Linking computer dates (time) to spreadsheet dates that have formu	bigisle	Microsoft Excel Worksheet Functions	2	3rd Jan 2010 08:05 PM
Copy/Paste 2009 dates into Tbale and they Show as 2008 Dates	ryguy7272	Microsoft Access	1	13th Nov 2008 02:13 AM
Toggle a range of Julian dates to Gregorian Dates and Back	=?Utf-8?B?UFNLZWxsaWdhbg==?=	Microsoft Excel Programming	4	8th May 2007 05:51 AM
Showing data between two dates in multiple subreports by enter two dates	Martijn	Microsoft Access Reports	0	26th Sep 2003 10:37 AM