How to convert Date to double in VBA?

**Whistlerek** · 07-31-2011, 04:50 AM

Hi I need to convert date "dd/mm/yy" to double in VBA.

I cannot find anything about that on the forum

Thanks

**royUK** · 07-31-2011, 04:54 AM

A date in excel appears as number formatted as a date. So assuming the ActiveCell contains a date,you could use

Please Login or Register  to view this content.

I would use a Long variable & CLng not CDbl

**Colin Legg** · 07-31-2011, 05:01 AM

If it's coming from a cell, you could also use the Value2 property

Please Login or Register  to view this content.

**Whistlerek** · 07-31-2011, 05:07 AM

Thanks, works great!

**royUK** · 07-31-2011, 05:10 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save