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

Hello,
How can I compare today's date to 2 other dates? Example:

fDate = Left$(Date$, 2) & Mid$(Date$, 4, 2) & Right$(Date$, 4)
If fDate is equal to or greater than(=) Nov.1,2004 AND equal to or less
than(=<) Nov.26,2004 Then MsgBox "Warning!"