Count number of cells with date <today's date

G

Guest

I need to count the number of cells in one column that contain a date that is
<= today's date. The dates are currently formatted as "General" numbers
rather than being formatted as "Date"
 

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

How to auto update date contained in formula 4
count the number of cells with a date <= today's date 3
count the number of cells within a column with a date <= today's d 2
Excel How to calculate in excel number of open actions that expired (older then today) 0
CountIF date problem 0
Difference in dates 4
change font color 2
Excel Help with dates 2

Top