L lhooker Registered User. Local time Today, 12:07 Joined Dec 30, 2005 Messages 423 Jul 29, 2010 #21 vbaInet, I realize that, but the results are wrong. The number of working days from 7/7/2010 to yesterday is not zero ("0"). It appears that the logic does not allow dates in the past. What do you think ?
vbaInet, I realize that, but the results are wrong. The number of working days from 7/7/2010 to yesterday is not zero ("0"). It appears that the logic does not allow dates in the past. What do you think ?
V vbaInet AWF VIP Local time Today, 17:07 Joined Jan 22, 2010 Messages 26,374 Jul 29, 2010 #22 No, nothing wrong. Have a think. The function is as follows: Workingdays("FIRST Date", "SECOND Date") Second is always bigger than first.
No, nothing wrong. Have a think. The function is as follows: Workingdays("FIRST Date", "SECOND Date") Second is always bigger than first.
L lhooker Registered User. Local time Today, 12:07 Joined Dec 30, 2005 Messages 423 Jul 29, 2010 #23 vbaInet, Thanks for the format . . . I see now . . . Thanks for all your help ! ! !
V vbaInet AWF VIP Local time Today, 17:07 Joined Jan 22, 2010 Messages 26,374 Jul 29, 2010 #24 Glad you got it sorted. You're welcome!