Hello, I am trying to use Sumproduct to calculate the difference between two dates per row, using the following:
Column A = From Date
Column B = To Date
I have tried both of the following which do not work:
Sumproduct(B:B-A:A)
Sumproduct((--B:B)-(--(A:A)))
Any help would be appreciated
Column A = From Date
Column B = To Date
I have tried both of the following which do not work:
Sumproduct(B:B-A:A)
Sumproduct((--B:B)-(--(A:A)))
Any help would be appreciated