Posted to microsoft.public.excel.programming

external usenet poster

Posts: 21

DateDiff("w") -- problem

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell	Steve Kay	Excel Discussion (Misc queries)	2	August 8th 08 01:54 AM
"DATEDIFF" LOCATION IN EXCEL 2007	dickvw	Excel Worksheet Functions	1	December 14th 07 06:48 PM
problem with Linking workbooks via "copy" and "paste link"	Arkitek	Excel Discussion (Misc queries)	0	December 19th 06 10:03 PM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next	BCB	New Users to Excel	7	May 13th 06 10:02 PM

All times are GMT +1. The time now is 11:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us