count the presence of a date as 1

  • Thread starter Thread starter WLWTNG
  • Start date Start date
W

WLWTNG

I am building a sales tracking chart which includes a date when an item is
sold. I need to count the number of sales based on whether or not a date has
been entered.
 
Dates are numbers that are formatted nicely in excel.

If the range only consists of numbers (just dates (no other numbers like money,
times...), non-numeric text or empty cells, you could use a formula like:

=count(a2:a10)
 
Back
Top