Week count

[Christopher Naveen]

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!!!!!!!!!!

 

[FSt1]

hi
if your dates were in a1(20/12/07) and b1(26/12/07) then in c1 put....
=(b1-c1)/7
To calculate workdays...
=networkdays(a1,b1)
the networkdays function comes with the Analysis ToolPak, an addin that came
with your install disk but does not install by default. if you get the #NAME?
error, you will have to install the toolpak. then on the menu bar....
Tools>Addins>check Analysis ToolPak>ok.

Regards
FSt1

 

[Bob Phillips]

Weeks

=INT((B2-B1)/7)

Days

=NETWORKDAYS(B11,B12)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)