如何在Excel中每周，每两周和每月计算两个日期之间的周五总数?
我的开始日期是2016年1月1日，结束日期是2016年12月31日.我想计算范围之间每两周的星期五总数.
My Start Date is 1/1/2016 and End Date is 12/31/2016. I want to calculate total biweekly Fridays between range.
双周刊:如果我给出每季度范围的开始日期为2016年1月1日，结束日期为2016年3月31日，则我的公式可以正常工作 = CEILING(INT((WEEKDAY(A1-6)-A1 + A2)/7)/2,1)，但在半年度和年度情况下失败
BI-WEEKLY: If I give Quarterly range Start Date is 1/1/2016 and End Date is 3/31/2016, my formula working fine =CEILING(INT((WEEKDAY(A1-6)-A1+A2)/7)/2,1) but failed for Semi annual and Annual case
每周:每周 INT((WEEKDAY(A1-6)-A1 + A2)/7 的公式在所有情况下均能正常工作.
WEEKLY: Formula for weekly INT((WEEKDAY(A1-6)-A1+A2)/7 working fine in all cases.
用于计算Excel中每周，每两周和每月一次的两个日期之间的星期五总数的公式.
A1 =期间的开始日期， A2 =期间的结束日期，
如果在Excel中，星期从星期日开始，则星期五的值将为 6
Formulas to calculate total number of Fridays between two dates in excel on weekly, biweekly and monthly basis.
A1 = Start date of the period , A2= End date of the period,
If in Excel , week is start with Sunday then the value for Friday will be 6
Formula for Weekly = INT((WEEKDAY(A1-6)-A1+A2)/7
Formula for Bi - Weekly = CEILING(INT((WEEKDAY(A1-6)-A1+A2)/7)/2,1
Formula for Monthly = (YEAR(A2)-YEAR(A1))*12+MONTH(A2)-MONTH(A1)+1
希望它对我有用:)