Search:

Type: Posts; User: Deepak Churiwal; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Questions from the 2013 Modeloff awards ceremony

    My answers: -
    Question 1
    =IF(AND($E18<=H$17,$F18>=H$16),MIN(H$17-$E18,H$17-H$16,$F18-H$16,$F18-$E18)+1,0)
    Question 2
    =INDEX($E$18:$H$21,ROWS(18:$21),COLUMNS(E:$H))
    Question 3...
  2. Replies
    5
    Views
    2,897

    Re: Splitting Date Range into Months

    Try writing the below formula in cell A3 and then drag it down


    =TEXT(IF(EOMONTH($A$1,COUNTA(A$1:A1)-2)+1<$A$2,EOMONTH($A$1,COUNTA(A$1:A1)-2)+1,""),"mm/dd/yy")&" -...
Results 1 to 2 of 2