Vba: Using Evaluate Sumproduct / Countifs combination for Date

Hello,

i am trying to use sumproduct/countifs function and one of the values to be compared is Date. If it is a not a "date" type it works but otherwise it throws error value. can someone help me out on this please?

Atype and Adate are defined names

Please Login or Register  to view this content.

Thanks

You could use the "IsDate" function to check if it is a date or not.

the value stored is in date format only.