Thread: can anyone tell me whats wrong with this line of code?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BRC BRC is offline
external usenet poster
  
Posts: 10
Default can anyone tell me whats wrong with this line of code?
dim enddt
enddt = Range("c16").value
Range("d16").formula = "=if(" & endDt & " " & Date & " , " & Date &
" , " & endDt & ")"

What I am getting is in cell d16 is something like
"=IF(12/15/1999 1/5/2007, 1/5/2007, 12/15/1999)"
which is translating (displayed) as 1/0/1900
what i was trying to get is 12/15/1999
Cell d16 is formated a date m/d/yyyy
Thanks for any advice. BRC

Reply With QuoteReply With Quote