Count Days Formula Not Working

Hello

I would like to count the days between 2 dates and have tried various formulas like:

1. (B2 - A1) = 4
2. DATEDIF (B2, A1, "d") = 4

Date range is : Cell A1 = Mon 6/01/2025 Cell B2 = Fri 10/01/2025

And I get 4 days, but I want to include Monday (?) or Friday (?) as a day so the answer should in theory be 5 days.

Is there a different formula I should use?

Regards
Andrew

You could simply add +1 onto the end of the formula.

I would use:

=B2-A1+1

But you could also use:

=DATEDIF(A1,B2,"d")+1

That doesn't matter.

You have 3 options: =B2-A1+1 or =DAYS(B2,A1)+1 or =DATEDIF(B2,A1,"d")+1