M
Michael J. Malinsky
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.
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.