Using OR with COUNTIF function

Erica Hodgdon

I have a sheet with a "Start Date" column and a "Completed Date" column, and I am trying to get the month end count, meaning it was either started OR completed in September. Both columns are formatted as "Date" columns. Can anyone help me?

Thank you!

-Erica

David Tutwiler

=IF(OR(MONTH([Start Date]@row = 9, MONTH([Completed Date]@row = 9), 1, 0)

This formula just returns a 1 or 0 if the month is September. You could also use this in a COUNT function, but I wasn't sure what all you were doing with it.

David Tutwiler

=IF(OR(MONTH([Start Date]@row = 9, MONTH([Completed Date]@row = 9), 1, 0)

This formula just returns a 1 or 0 if the month is September. You could also use this in a COUNT function, but I wasn't sure what all you were doing with it.

David Tutwiler

Sorry, it is missing a parentheses after the 9:

=IF(OR(MONTH([Start Date]@row = 9, MONTH([Completed Date]@row = 9)), 1, 0)