yogi_Compute Instances Of Specified Weekday Between Dates In Cells A2 And A3

                                          Google Spreadsheet   Post  #1414
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov 09, 2013
question by iantrapl (http://productforums.google.com/forum/?zx=plc9xn1kd674#!mydiscussions/docs/oVhDPU8WWuM
need formula to determine number of times a date or day occurs within two dates, trying to convert from EXCEL to Google
start date: 02/1/13  A1

end date: 05/06/13 A2

day of week=5       B1

Excel format;

="The day  ' "&CHOOSE(WEEKDAY(b1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")&" '  occurs  "&SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2&":"&A1)))=b1))&"  times  between  " &TEXT(A1,"m/dd/y ")&" through  "&TEXT(A2,"m/dd/y  ")

Thanks for the assist,Have most of the other date calculation done.

--------------------------------------------------------------------------------------------------------------------------------------------