I have a problem calculating business day because it is short on one day:
For example:
TODAYDATE/WYYMD=&BEG;
DIFF/I8=DATEDIF(TODAYDATE, ENDDATE, 'BD');
Suppose TODAYDATE = 20041211 (Saturday)
ENDDATE = 20041218 (Saturday)
The diff will come out as 4; however, I wanted to come out as 5. The answer 5 will give me Monday, Tuesday, Wednesday, Thursday, and Friday.
I understand why it is giving me 4 because
20041217(Friday) - 20041213(Monday) = 4 days
Is there a code that work around this problem in order for me to get an answer of 5.
Thank you,
For example:
TODAYDATE/WYYMD=&BEG;
DIFF/I8=DATEDIF(TODAYDATE, ENDDATE, 'BD');
Suppose TODAYDATE = 20041211 (Saturday)
ENDDATE = 20041218 (Saturday)
The diff will come out as 4; however, I wanted to come out as 5. The answer 5 will give me Monday, Tuesday, Wednesday, Thursday, and Friday.
I understand why it is giving me 4 because
20041217(Friday) - 20041213(Monday) = 4 days
Is there a code that work around this problem in order for me to get an answer of 5.
Thank you,