Help with excel formula

[eviehc123]

Hi all,

I am having issues with the following formula:
=COUNTIFS('Raw Data - Travel'!D2:D350,">"&'Total Summary Data - Travel'!B3,'Raw Data - Travel'!D2:D350,"<"&'Total Summary Data - Travel'!C3)

Cells B3 & C3 are start and end dates.

D2:D350 contains dates.

The formula works perfectly fine with the data that is already there. However, as soon as I paste (as values) new dates in collumn D, it just stops working. What I mean by stops working is it doesn't pick up any dates in the specified range even if there are dates there. For example, It displays 0 even if it should show 3.

I have racked my brain to try and work out why this may happen but I am stumped.

Does anyone know why this may occur?

Thanks in advance

 

[Fluff]

Make sure the dates you have pasted in are real dates & not text.

 

[eviehc123]

Make sure the dates you have pasted in are real dates & not text.

Thanks! The formatting is correct on the spreadsheet I'm pasting into but the dates are stored as text on the spreadsheet I'm copying the dates from!! Perfect quick solve haha. Thank you.

 

[Fluff]

You're welcome & thanks for the feedback.