Peo -

I suspect you are right about them not 'touching' datedif; however, it is
very interesting that there is a robust DATEDIFF() function in SQL Server
that IS documented and that DOES have a WEEK argument. Matter of fact, it
does QUARTERS, HOURS, MINUTES, SECONDS, and MILLISECONDS, too.

Odd, eh?


"Peo Sjoblom" wrote:

You are right, one tends to forget that a majority of people posting here
is using the web interface and not a newsreader.

Btw they won't touch that function with a 10 foot
pole. It is only documented in Excel 2000.


Weeks are easy enough,

=(end_date-start_date)/7

or maybe include round so you don't get any decimals

--


Regards,


Peo Sjoblom

"Brad" wrote in message
...
I agree that this is a newsgroup, but why have a dropdown for "suggestion
for
microsoft" if not to provide for suggestions - and it appears people can
vote
for the suggestion. What am I missing?


"Bernard Liengme" wrote:

This is a newsgroup of your peers. It is not somewhere that Microsoft
goes
for 'advice'
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Brad" wrote in message
...
Currently day, month, year and combinations of these can be used with
this
function. Please add week to this function.


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc