Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2016
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. =COUNTIFS(ROUNDUP(MONTH('sheet-label'!B2)/3),1)
  2.  
  3. =COUNTIFS(ROUNDUP(MONTH('sheet-label'!B1:B50)/3),1)
  4.  
  5. function countQuarterByYear(date, quarter, year) {
  6.  
  7. var counter = 0;
  8. var arrayLength = date.length;
  9. var dateYear;
  10. var dateQuarter;
  11. var dateTemp;
  12.  
  13. for(var i = 0; i < arrayLength; i++) {
  14.  
  15. dateTemp = date[i];
  16.  
  17. dateYear = dateTemp.getYear;
  18.  
  19. dateQuarter = dateTemp.getMonth;
  20. dateQuarter = Math.ceil(dateQuarter/3);
  21.  
  22.  
  23. if ((dateYear == year) && (dateQuarter == quarter)){
  24. counter++;
  25. }
  26.  
  27. }
  28. return counter;
  29.  
  30. }
  31.  
  32. function test() {
  33. countQuarterByYear(["2/7/2016", "8/5/2015"], 2, 2015);
  34.  
  35. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement