I have the functions in the attached file.
I have a sumproduct function with two conditions.
When the Condition is linked to column formatted as Date & Time it doesnt give the proper answer, but when the same date is formatted as decimal number it gives correct answer.
Is there are a way to build this into the function without having to create a helper column ???
Bookmarks