View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
kirkm[_8_] kirkm[_8_] is offline
external usenet poster
 
Posts: 166
Default Need a hand with date calc

On Sun, 1 Mar 2009 20:30:00 -0800, JLGWhiz
wrote:

Will this work?

Sub dt()
MsgBox DateDiff("ww", Range("A2").Value, Range("A3").Value)
End Sub


Thanks, but I think that'll give the number of weeks between two
ranges ?