Thread: Calculate number of weeks between dates in Excel 2000
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Toppers
 
Posts: n/a
Default Calculate number of weeks between dates in Excel 2000
try:

=int(b1-a1)/7) where A1, B1 are start/finish dates

HTH

"Darlene" wrote:

How can I calculate the number of weeks between two dates in different years?
Thanks
Reply With QuoteReply With Quote