Posted to microsoft.public.excel.programming

Stephen Bullen[_4_] Stephen Bullen[_4_] is offline

external usenet poster

Posts: 205

Calculations with different date formats

Hi Derek,

How can I force
VBA to interpret my date format correctly?

User DateSerial(y,m,d) instead of the #m/d/y# style, which welcomes
confusion.

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date Calculations	Erika	Excel Discussion (Misc queries)	3	April 8th 10 09:58 PM
Date Calculations before date entered	Ma2Weir	Excel Discussion (Misc queries)	8	February 1st 07 03:34 AM
Date calculations	TJAC	Excel Discussion (Misc queries)	4	May 24th 06 05:36 PM
Date calculations	Brian	Excel Discussion (Misc queries)	2	March 8th 06 08:43 PM
Date Calculations	Carla Goodloe	Excel Programming	1	April 8th 04 12:29 AM

All times are GMT +1. The time now is 03:27 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us