Tuesday, June 28, 2011

yogi_Count Number Of Specified WeekDay In A Given Time Period

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
Termanator13 said:
how do I calculate the number of Fridays or any day of the week in a month?
I have a expence sheet, and I need to know how often I get paid in a month to better plan for this, this is on Fridays.
In the following I have provided solution to the problem in a more generalized way