Count the Number of Cells Containling Dates

		Microsoft Office Forums > Microsoft Excel > Excel
Count the Number of Cells Containling Dates

FAQ

Thread Tools

Display Modes

05-19-2019, 09:20 AM

Logit

Windows 10 Count the Number of Cells Containling Dates

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

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")

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
count the number of text in a cell based off a different cells text	Kubi	Excel	4	08-24-2017 05:53 PM
count a number of cells based on the beginning of a order number	Kubi	Excel	2	08-06-2017 08:54 PM
Distribute text in one cell across a range of cells (overcoming selection.range.cells.count bug)	slaycock	Word VBA	0	02-18-2017 07:00 AM
How to Count from Different Cells?	Shahzad	Excel	3	06-26-2010 01:06 AM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:58 PM.