VBA DateDiff interval argument for "w" isn't working

[sefMI]

Hi,
According to the VBA documentation the arguement of "w" should return the number of weekday (i assume m-f) between two dates when used in the datediff() function. When I do this it returns a -2 where my dates are 6/15/12 and 5/29/12. What gives?

Scott

 

[MickG]

If you look at vb Help (see Remarks), the "w" appears to count the number of weeks !!!

 

[sefMI]

Odd b/c the documentation i get from the editor is that "ww" counts weeks and "w" counts week days. Not the end of the world but would have been nice.

 

[Rick Rothstein]

Odd b/c the documentation i get from the editor is that "ww" counts weeks and "w" counts week days. Not the end of the world but would have been nice.

From the Remarks section of the VB help file for DateDiff (see red highlighted text)...

"To calculate the number of days between date1 and date2, you can use either Day of year ("y") or Day ("d"). 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. It counts the number of Sundays between date1 and date2. DateDiff counts date2 if it falls on a Sunday; but it doesn't count date1, even if it does fall on a Sunday."