Home › Forums › Discussion › Application.DateDifference – Always Uses Standard Calendar
Tagged: Application.DateDifference Calendar
I have written some VBA to assign percent complete to Text1.
Select Case taskRes Case “FiveDaysAWeek” oSubTask.Text1 = CInt(((Application.DateDifference(taskStart, Now(), FiveDaysAWeek) / taskDuration) * 100)) & “%” Case “SevenDaysAWeek” oSubTask.Text1 = CInt(((Application.DateDifference(taskStart, Now(), SevenDaysAWeek) / taskDuration) * 100)) & “%” End Select
The calculation for FiveDaysAWeek is correct but for SevenDaysAWeek calendar it still calculates the difference based on working 5 days a week and not 7.
Any input on what I am doing wrong would be appreciated.
Mail (will not be published) (required):
Please complete this equation so we know you’re not a robot. 2 + 1 =
Please enter your username or email address. You will receive a link to create a new password via email.
Enter the destination URL
Or link to existing content