Solved: Date format problem

[justdriving]

Hi,

In attached Sheet, I am requesting a VBA code which can calculate Col R to Z without having any formatting problem with Date2 mentioned in H Col and R3, W3. I think there was formatting problem because of which Col X to Z were not calculated.

[Bob Phillips]

Try

=SUMPRODUCT(--($A$2:$A$151=$R4),--($E$2:$E$151="S"&COLUMN(A$1)),--($H$2:$H$151=$R$3))

and

=SUMPRODUCT(--($A$2:$A$151=$W4),--($E$2:$E$151="S"&COLUMN(A$1)),--(TEXT($H$2:$H$151,"mmmm")=$W$3))

[justdriving]

Try

=SUMPRODUCT(--($A$2:$A$151=$R4),--($E$2:$E$151="S"&COLUMN(A$1)),--($H$2:$H$151=$R$3))

and

=SUMPRODUCT(--($A$2:$A$151=$W4),--($E$2:$E$151="S"&COLUMN(A$1)),--(TEXT($H$2:$H$151,"mmmm")=$W$3))


Hi Bob,

Thanks. I request you to please convert above program in VBA using Range notation or Cells() notation. It will help me. My excel worksheet does not recognize Dates.

[justdriving]

Hey Bob,

Please don't mind my signature. I was so happy that I wrote that. Anyway, I solved this problem by recording macro. It worked.