software

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,quot;dquot;)

I tried simply changing the quot;dquot; to quot;wquot; 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.
Maybe:

=DATEDIF(B2,X2,quot;dquot;)/7 ??

There doesn't appear to be a quot;wquot; option

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

www.cpearson.com/excel/datedif.htm

Regards

Trevorquot;Fishquot; gt; wrote in message
. net...
gt; What would the function (if any) be to calculate the number of weeks
gt; between two dates.
gt;
gt; Someone helped me with a function that calculates the number of days as:
gt;
gt; =DATEDIF(B2,X2,quot;dquot;)
gt;
gt; I tried simply changing the quot;dquot; to quot;wquot; in hopes the d was short for days
gt; and W would be short for weeks, but it didn't work.
gt;
gt; I'm new to Excel and using Excel 2002. Is there a function that can
gt; calculate the number of weeks between two dates?
gt;
gt; Thanks.
gt;
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

quot;Fishquot; gt; wrote in message
. net...
gt; What would the function (if any) be to calculate the number of weeks
gt; between two dates.
gt;
gt; Someone helped me with a function that calculates the number of days as:
gt;
gt; =DATEDIF(B2,X2,quot;dquot;)
gt;
gt; I tried simply changing the quot;dquot; to quot;wquot; in hopes the d was short for days
gt; and W would be short for weeks, but it didn't work.
gt;
gt; I'm new to Excel and using Excel 2002. Is there a function that can
gt; calculate the number of weeks between two dates?
gt;
gt; Thanks.
gt;

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)amp;quot; weeks quot;amp;MOD(B1-A1,7)amp;quot; daysquot;--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=521961
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)amp;quot; weeks quot;amp;MOD(B1-A1,7)amp;quot; daysquot;--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=521961