Function to calculate the nuber of weeks between dates?

[Fish]

What would the function (if any) be to calculate the number of weeks between
two dates.

Someone helped me with a function that calculates the number of days as:

=DATEDIF(B2,X2,"d")

I tried simply changing the "d" to "w" in hopes the d was short for days and
W would be short for weeks, but it didn't work.

I'm new to Excel and using Excel 2002. Is there a function that can
calculate the number of weeks between two dates?

Thanks.

 

[Trevor Shuttleworth]

Maybe:

=DATEDIF(B2,X2,"d")/7 ??

There doesn't appear to be a "w" option

Have a look at Chip Pearson's page on the subject:

http://www.cpearson.com/excel/datedif.htm

Regards

Trevor

 

[William]

Hi Fish

Can you not use your existing formula to calculate the number of days and
then divide the result by 7?

--

Regards

William

XL2003

(e-mail address removed)

 

[daddylonglegs]

You don't really need DATEDIF for calculating the number of days between
2 dates

=X2-B2

would suffice

so for weeks

=(X2-B2)/7

or if you want weeks and days in text...

=INT((B1-A1)/7)&" weeks "&MOD(B1-A1,7)&" days"

 

[daddylonglegs]

You don't really need DATEDIF for calculating the number of days between
2 dates

=X2-B2

would suffice

so for weeks

=(X2-B2)/7

or if you want weeks and days in text...

=INT((B1-A1)/7)&" weeks "&MOD(B1-A1,7)&" days"