Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
DateDiff("w") -- problem
I'm not aware of the "w" or "ww" arguments. Where did you find them
documented? "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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
DateDiff("w") -- problem
Found in the Help documentation for Excel ("DateDiff Function").
"Niek Otten" wrote in message ... I'm not aware of the "w" or "ww" arguments. Where did you find them documented? "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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
DateDiff("w") -- problem
Hi Niek!
zSplash is talking about the vba DATEDIFF not the mysterious Workbook function DATEDIF Datediff is documented in Help for all versions since at least Excel 97. -- Regards Norman Harker MVP (Excel) Sydney, Australia Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "Niek Otten" wrote in message ... I'm not aware of the "w" or "ww" arguments. Where did you find them documented? "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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
DateDiff("w") -- problem
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
DateDiff("w") -- problem
Absolutely right, Norman. I always assumed they were just the VBA and the SS
version of one and the same thing, but that turns out to be completely wrong. Thanks! -- Kind Regards, Niek Otten Microsoft MVP - Excel "Norman Harker" wrote in message ... Hi Niek! zSplash is talking about the vba DATEDIFF not the mysterious Workbook function DATEDIF Datediff is documented in Help for all versions since at least Excel 97. -- Regards Norman Harker MVP (Excel) Sydney, Australia Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "Niek Otten" wrote in message ... I'm not aware of the "w" or "ww" arguments. Where did you find them documented? "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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
DateDiff("w") -- problem
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 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
DateDiff("w") -- problem
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 |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
DateDiff("w") -- problem
is it available under tools=Addins? If so, check both Analysis Tookpak
and Analysis Toolpak - VBA. The later contains the VBA callable versions of the functions. If not go to the control panel and do add/remove software and start office install. -- Regards, Tom Ogilvy 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
"DATEDIFF" LOCATION IN EXCEL 2007 | Excel Worksheet Functions | |||
problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |