Hi,
I am using a countif function and I'm running into a problem with using a conditional argument as the criteria.
I have a spreadsheet in which a column shows due dates for actions and I wish to count how many actions are past their due date based on comparing the values in the column with a date typed into a cell on a different sheet.
=COUNTIF('In Progress'!K3:K500,"<=Sheet1!B1")
The formula works if I replace the 'less than' sign with a 'greater than' sign and shows the correct number of cells where dates are greater than the date in B1 but just displays a 0 if I put in the 'less than' sign to try and get it to count cells where the date is less than the date in B1.
I hope I'm not missing anything simple but it seems illogical that the formula should work for 'greater than' but not for 'less than'
Any help greatly appreciated!
Thanks
Bookmarks