View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Terri Terri is offline
external usenet poster
 
Posts: 110
Default Compare current date to 2 dates

Hello,
How can I compare the current date to 2 other dates. Example:
fDate = Left$(Date$, 2) & Mid$(Date$, 4, 2) & Right$(Date$, 4)
I need a MsgBox to open if fDate is equal to or greater(=) than Nov. 1,
2004 AND equal to or less than(=<) Nov. 26, 2004.
Thank you for your help,
Terri