COUNTIFS Formula Not Counting "1/0/1900" Date

  • Using the "COUNTIFS" function in Excel, I am trying to tabulate a total sum (of counts) across a number of ranges / criteria. The formula is working properly until I ask Excel to count the number of dates marked in a column as "1/0/1900." Everything leading up to this part of the formula works (I broke down into parts to prove it). Because I am not referencing the "1/0/1900" date correctly (I'm assuming), my total keeps returning back to 0 - thus, negating the rest of the "good" part of the formula. Net / net: I need to count the "1/0/1900" dates, but don't know how. Thx. - Jamie

  • Hi

    please post a sample with some representative data. Are your dates real dates ( right aligned ) or text looking like dates ( left aligned). (assuming no manual alignment)

    If the latter select the date range Click Data - Text to columns - Finish. If right aligned you are OK.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!