COUNTIFS - Date Columns

[Jesse_Belle]

Hello,

In my spreadsheet I have Column A with dates and Column O with dates. My formula is supposed to count the # of dates in Column A if there are not dates in Column O. I'm either getting a too few arguments for this function for or #VALUE. Any guidance is greatly appreciated!

[#2]

@Jesse_Belle would be helpful if you could show the formula you are using.

[#3]

@Riny_van_Eekelen 

This is what I have =COUNTIFS(A47:A60,O47:O60,"<>")

[#4 · Accepted solution]

@Jesse_Belle Perhaps this works for you:

=COUNT(A47:A60)-SUM(COUNTIF(A47:A60,O47:O60))

It counts the total number of dates minus the number of matching dates leaving you with the number of dates in A that are not in O.

[#5]

@Riny_van_Eekelen 

Perfect. Thank you!