View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal[_3_] Robert Crandal[_3_] is offline
external usenet poster
 
Posts: 161
Default Basic question about dates

Is it possible to determine the integer value of the current date?

For example, I thought this code might help, but it doesn't:

MsgBox CInt(Date) ' Returns overflow error

I get the impression that every date in VBA is represented by
a unique integer. Is that right? If so, how do you find the
integer value for any date?