Thread: Week count
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Christopher Naveen[_2_] Christopher Naveen[_2_] is offline
external usenet poster
 
Posts: 58
Default Week count

Hi,
Can any one tell me how can we calculate the Number of weeks between two
dates.

Also pls tell me separate function which calculates only the working days
(Monday - Friday) and shud return the count of days.

Ex : start date is 20/12/2007 and End date is 26/12/2007.

Answer shud be 5 Days.

Thanks in advance!!!!!!!!!!