Function to calculate the nuber of weeks between dates?

  • Thread starter Thread starter Fish
  • Start date Start date
F

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.
 
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)
 
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"
 
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"
 
Back
Top