Formula to caculate the numbber of days i need to charge for using dates?

[tonywatsonhelp]

Hi Everyone,
Please help i'm getting a bit confused here.

What it is is i have two coloumns "In date" and "Out Date"

In date is column G
Out Date is Column J

So we charge whilst an item is "In stock" per day.

What I want to be able to do is instert a start date and end date and caculate how many days each row was in stock durring that period in days.

so for example:

					Days in stock between
					Q7	S7
	Column G		Column J	Column M	01/06/2021	15/06/2021
	In Date		Out Date	Days in stock
	1/1/2020		27/7/2021	15
	14/06/2021			1	The red are the numbers i'm try to caculate
	01/05/2021		03/06/2021	3
	1/04/2020		15/07/2020	0

 

[ChrisFoster]

Just so I understand correctly, you just need a formula to know how many days are between two dates?

 

[tonywatsonhelp]

Hi, well, its not as simple as that,
I want to add in a start date and end date, and i want the formula to tell me how many days if any that row has for that period,
so for example I might choose Start date 01/06/2021 end date 15/06/2021 and I want to caculate how long i had that row in stock between those dates by using there start date and end date as show above.
Hope that helps

 

[Fluff]

How about

+Fluff 1.xlsm
	G	H	I	J	K	L	M	N	O	P	Q	R	S
6
7											01/06/2021		15/06/2021
8
9	01/01/2020			27/07/2021			15
10	14/06/2021						1
11	01/05/2021			03/06/2021			3
12	01/04/2020			15/07/2020			0
13
Master

Cell Formulas
Range	Formula
M9:M12	M9	=IF(J9="",DATEDIF(MAX($Q$7,G9),$S$7,"d"),IF(OR(G9>$S$7,J9<$Q$7),0,DATEDIF(MAX($Q$7,G9),MIN($S$7,J9),"d")+1))