Saturday, November 9, 2013

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.
--------------------------------------------------------------------------------------------------------------------------------------------


No comments:

Post a Comment