SindyHanner
Qrew Member
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: Weekdaysub - Count end date
I have static dates for the most part. Always 1-15 or 16-last day of the month. I don't know if that will make a difference. The +Days(1) worked for the September example but depending on the day of the week that the last day of the pay period falls will be a moving target. Sindy Hanner Sr NOC Operations Support Specialist Network Operations Control (469) 603-0939 HDQ-NOC14Views0likes1CommentWeekdaysub - Count end date
Hello, I'm trying to calculate the number of weekdays in a range but don't want the count to stop the day before the end date. Example date ranges: 9/16-9/30 has 11 weekdays (starts on Friday and ends on Friday) 10/01-10/15 has 10 weekdays (starts on Saturday and ends on Saturday) Formula: WeekdaySub([Pay Period End Date],[Pay Period Start Date]) Returns the correct count for the October date range however it does not count correctly for the September range. Not sure what direction to go from here.... Please help! ------------------------------ Sindy Hanner ------------------------------42Views0likes8Comments