count the presence of a date as 1

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.
 
D

Dave Peterson

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
How to ignore a column of numbers in Grand Total for rows 1
Pivot Table Calculated Field 0
Space at end of multi page list to accommodate new entries 1
Display weeks from a Milestone 0
Print (physical or pdf) not respecting format of source document 0
How to count the numbers in a Word document? 0
Trying to create custom labels from an csv file + Need items numerically counted out 0

Top