Excel Formula Count cells where value is date

0 votes

When a cell's value is a date, I need the formula to perform a COUNTIF (or a similar function) on the cell range and increase the counter. Basically, something like this:

=COUNTIF(range, if_date())

I haven't been able to locate a practical test for the if date() portion of the query. Is it possible to test a cell to see if it has a date?

Dec 10, 2022 in Others by Kithuzzz
• 38,010 points
999 views

1 answer to this question.

0 votes

Dates in Excel are just formatted numbers, so this is difficult to do with worksheet functions. The only function that lets you investigate a cell's format is CELL (and you can't apply that to a range, so a helper column would be needed). However, if all you have are dates and blanks or dates and text, you can just use COUNT, i.e.

=COUNT(range)

That counts numbers, therefore if you wish to separate dates from numbers, it won't be sufficient. If so, the number range could be used. For instance, if the dates are all very recent and the numbers in the range are all lower than 10,000, you could use this version to omit the numbers.

=COUNTIF(range,">10000")
answered Dec 11, 2022 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Excel Formula which places date/time in cell when data is entered in another cell in the same row

Here's how to accomplish things in another ...READ MORE

answered Dec 11, 2022 in Others by narikkadan
• 63,420 points
786 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,236 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,423 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,670 points
697 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 23,260 points
2,329 views
0 votes
1 answer

Excel - How can I get the average of cells where the value in one column is X and the value in another column is Y?

Use AVERAGEIFS ... =AVERAGEIFS(C2:C13,A2:A13,"Yellow Typ ...READ MORE

answered Nov 11, 2022 in Others by narikkadan
• 63,420 points
1,003 views
0 votes
1 answer

Formula for inserting a thumbnail picture into excel cell, based on another cell's value

Here is a really excellent tutorial on ...READ MORE

answered Oct 31, 2022 in Others by narikkadan
• 63,420 points
1,105 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP