Thread: VBA Date Format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] aidan.heritage@virgin.net is offline
external usenet poster
  
Posts: 244
Default VBA Date Format
Ignore the format, go with INT

if INT(dBD)int(dRBD)

which will check the integer (and therefore DATE) part of the cell only

Reply With QuoteReply With Quote