View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default calculating number of weeks between two dates

=WEEKNUM(B1)-WEEKNUM(A1)


"vnsrod2000" wrote:

Hello. I have three columns:
start date
end date
duration
What function do I use to calculate the number of weeks the dates entered in
the first two columns?

Thanks.