Microsoft Office Forums - View Single Post - [Solved] Count the Number of Cells Containling Dates

Thread: [Solved] Count the Number of Cells Containling Dates

View Single Post

Old

05-19-2019, 09:20 AM

Logit

Logit is offline

Logit uses Windows 10

Windows 10 Logit uses Office 2007

Logit uses Office 2007

Office 2007

Expert

Join Date: Jan 2017

Posts: 587

Logit is a jewel in the rough

Logit is a jewel in the rough

Logit is a jewel in the rough

Logit is a jewel in the rough

Default

CAUTION: This formula will count anything that is a number. If you column has more than dates and those entries are a number, this formula will count them as well.

=COUNTIF(A:A,">1/1/1900")

Reply With Quote