LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 37
Default Convert date to serial number in VBA

I have a couple of dates that are input via UserForm and are then used in
VBA calculations. Something like EndDate-BeginDate+1 gives the number of
days (so January 31, 2003 minus January 1, 2003 results in 31 days). Due to
calculations elsewhere in my code, this doesn't seem to be doing the trick.
What I'd like to do within VBA is covert the dates to serial numbers so
September 10, 2003 would be converted to 37874 before any calculations are
performed. I've look high and low and can't find help on the boards or in
the knowledge base or in help. Either its not there or I fried my brain.

TIA.
Mike.

--
Michael J. Malinsky



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
convert serial number into date santhu Excel Discussion (Misc queries) 2 October 28th 06 10:27 AM
Serial number of Date Gazzr Excel Worksheet Functions 2 March 24th 06 08:59 AM
Convert SERIAL date back into dd/mm/yy format? Aussie CPA Excel Worksheet Functions 6 September 30th 05 02:05 AM
How do I convert Date serial number to date rdunne Excel Worksheet Functions 1 April 12th 05 03:04 PM
How do I convert a serial number to the month, day, and year in E. Judy Excel Discussion (Misc queries) 2 December 15th 04 03:38 PM


All times are GMT +1. The time now is 08:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"