I have a formual '=SUMPRODUCT(--($E$2:E4635="NPR"),--($N$2:N4635=N4635),--($I$2:I4635<=I4635),--($I$2:I4635>=I4635-30))' which I thought worked fine, but have just noticed that the date format in cell 'I' also includes the time '31/12/2015 17:45:34'.
When I change the date to exclude the time, the formula works fine. Looking for some advise on :
1. Is there a way to include the date and time format into the formula?
2. Or would I have to split the date and time into two cells?
Any advise would be grateful.