Counting number of dates in a column earlier than today

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
Please can someone advise me on the formula I require for this problem.

I would like to calculate the number of dates in a specified column, that
equal to the current date or the date has passed.

Any suggestion will be greatly appreciated
 
Hi,
Try
=COUNTIF(G:G,"<="&TODAY())
Will return the number of dates in column G that are =< today
 
You must log in or register to reply here.

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

Sumif ">today()" 1
Excel Formula - Count Dates from another Sheet 8
Date Formula for number of days between a date and today 7
Excel How to calculate in excel number of open actions that expired (older then today) 0
Count number of days from the last entry? 2
counting dates using SUMPRODUCT 4
ormula for weeks from a date to today? 4
If cell is blank automatically enter today's date in the same cell 21

Back
Top