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,020 points
1,412 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,680 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,680 points
1,193 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,690 points
3,842 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,690 points
1,947 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,690 points
953 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
3,588 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,680 points
1,376 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,680 points
1,501 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