Formula to calculate total days in a column.

[asyamonique]

Good Day.
How can we calculate the total number of days in a column with a formula?
Thanks.

4

Date

22-Aug-2024

22-Aug-2024

23-Aug-2024

23-Aug-2024

23-Aug-2024

23-Aug-2024

23-Aug-2024

24-Aug-2024

24-Aug-2024

24-Aug-2024

24-Aug-2024

24-Aug-2024

24-Aug-2024

24-Aug-2024

25-Aug-2024

25-Aug-2024

 

[Kaper]

If the example is representative (you have a contignous set of days, just some are repeated, and dates are excel dates, not texts, which only look like a date), such formula shall be enough:

=max(A1:A100)-min(A1:A100)+1

if you receive as a result something that looks like a date change cell format to General or Number (Formatting may be needed, as Excel tends to return formula values in date format if dates are in formula data range).

 

[Joe4]

I am assuming that you want to count the number of unique days in your column, and the days may or may not be continuous.

It is too bad that you are still using Excel 2013 and not 2021 or 365, where you could use the new UNIQUE function.
The formula would just then be (for an example range A1:A10)

=COUNTA(UNIQUE(A1:A10))

With older version of Excel, you could use:

=SUMPRODUCT(1/COUNTIF(A1:A10,A1:A10))

as described here: Count unique values in a range with COUNTIF

 

[asyamonique]

If the example is representative (you have a contignous set of days, just some are repeated, and dates are excel dates, not texts, which only look like a date), such formula shall be enough:

=max(A1:A100)-min(A1:A100)+1

if you receive as a result something that looks like a date change cell format to General or Number (Formatting may be needed, as Excel tends to return formula values in date format if dates are in formula data range).

Thx.