Hi zSplash!

You and me both! I was misled by the intro description and didn't look
closer until I got the same results that you did.

Last resort? Read The Fine Manual.

See you around the newsgroups.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"zSplash" wrote in message
...
Thanks, Norman, for the help. I guess I just didn't read the
expanded help,
and assumed. Sorry.

So, how do I access (or install, if necessary) the "Analysis
Toolpack"
functions? This is new to me. (I don't see it in my References...)

st.

"Norman Harker" wrote in message
...
Hi zSplash!

I think that you are misunderstanding what DATEDIFF means by "w"
and
"ww" arguments.

Extract from Help:

When interval is Weekday ("w"), DateDiff returns the number of
weeks
between the two dates. If date1 falls on a Monday, DateDiff counts
the
number of Mondays until date2. It counts date2 but not date1. If
interval is Week ("ww"), however, the DateDiff function returns
the
number of calendar weeks between the two dates.

Both are counting weeks which is why in your case you are getting
the
same answer.

To count weekdays use the Analysis ToolPak NETWORKDAYS function.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and
Arguments)
available free to good homes.
"zSplash" wrote in message
...
I am trying to count weekdays, using the "w" argument
unsuccessfully. I get
the same value for "w" (weekday) as I do for "ww" (week). What
am I
doing
wrong?
Code:
estDays=DateDiff("w", ufm1.Calendar1, ufm1.Calendar2)

TIA