Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
convert serial number into date | Excel Discussion (Misc queries) | |||
Serial number of Date | Excel Worksheet Functions | |||
Convert SERIAL date back into dd/mm/yy format? | Excel Worksheet Functions | |||
How do I convert Date serial number to date | Excel Worksheet Functions | |||
How do I convert a serial number to the month, day, and year in E. | Excel Discussion (Misc queries) |