Hi all

Thanks in advance.

I have taken over a workbook with 1800 rows of data, it is populated with the day, month & year in columns D,E & F, then in column B the DATEVALUE function has been used to combine the three into a standard format date DD/MM/YYYY, the also in column A the WEEKDAY function has been used to calculate the day of the week.

Now i need to produce some stats using the COUNTIFS function based on data between two dates, i've been trying to use the dates from column B (the DATEVALUE results) but cant get it to work.

Is there any way of converting it / make it work without re inputting 1800 dates manually?

Please find a sample attached.

Regards

SiSample.xlsx