CODEWITHSUNDEEP
dateif-statementexcel-formulanumbers
Petra Marinšek
Petra Marinšek

Reputation: 13

Calculating dates in excel

enter image description here

I want to count the dates. 1 date = 1, 2 dates = 2... I have 2 dates and I want to prepare a formula if I have 2 dates, then this is total 2.

Upvotes: 0

Views: 47

Answers (2)

Forward Ed
Forward Ed

Reputation: 9894

Adjust the range references to suit your data.

=COUNTA(C2:G2)

Where C2:G2 is your first row under datum. This equation will count the number of non blank cells.

enter image description here

If 4.9. is a number an not text, then you could also use 

=COUNT(C2:G2)

Upvotes: 1

George Hanna
George Hanna

Reputation: 392

In Excel you could create a new column that checks if the cell is a date by doing =ISERROR(DAY(A1)). If it is a date the formula will return FALSE.

Then simply count all the cells with FALSE by doing =COUNTIF(B1:B10;FALSE) Here B1:B10 should be replaced with the cellrange of your new column that holds the true or false values

Upvotes: 1

Related Questions