Count Between Dates for Google Sheets

[yessir]

I'm looking for a formula that will be able to display the number of days between two dates. The formula would be in column C. Additionally for the third row since there's only one day I wouldn't an error to be displayed - I'd want it to be blank or display "0".

A B C

11/29/2022	11/30/2022	1
11/29/2022	11/30/2022	1
11/19/2022		0
11/19/2022	11/30/2022	11

Anything helps!

 

[Joe4]

For row 2, the formula in C2 would be:

=IF(AND(A2>0,B2>0),B2-A2,0)

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Another possible option

Fluff.xlsm
	A	B	C
1
2	29/11/2022	30/11/2022	1
3	29/11/2022	30/11/2022	1
4	19/11/2022		0
5	19/11/2022	30/11/2022	11
Data

Cell Formulas
Range	Formula
C2:C5	C2	=MAX(0,DAYS(B2,A2))

 

[yessir]

I'm using google sheets. Is there a way to return a blank cell instead of "0"? I'm trying to compile averages as well and realized that the 0's skew that data

 

[Fluff]

In future questions about Sheet should be posted in the General Discussion & Other Applications section of the board.
And you need to make it clear that you are using Sheets.
I have done that for you this time.

 

[Fluff]

To get a "blank" cell just change the final 0 in Joe's formula to ""

 

[Joe4]

In future questions about Sheet should be posted in the General Discussion & Other Applications section of the board.
And you need to make it clear that you are using Sheets.
I have done that for you this time.

They had originally posted it there, but there was no mention of Google Sheets, so I moved it to the Excel Questions forum.

yessir,
In addition to posting it in the "General Discussion & Other Applications" forum, please be sure to mention in your post somewhere (in the title and/or original question) that this is a "Google Sheets" discussion.

While this "General Discussion & Other Applications" forum is the place to post Google Sheets questions, it is not exclusively for Google Sheets questions.
So when posting to this forum, you should always mention what program you are asking about (especially since many people accidentally post Excel questions here too!).

Thanks