Does =days() stealing 1 day each time

[msword]

Just noticed that today is not included in the excel day counter, namely cell value equals to zero. Does it mean that 1 day was stealed all these years of using the formula? Is there an elegant way to fix this or remembering to add +1 in the end of the formula is a single option?

Book2
	A	B
1	0	23-Oct
Sheet1

Cell Formulas
Range	Formula
A1	A1	=DAYS(TODAY(), B1)

 

[msword]

Just want to keep my code clean and avoid Excel redundancy. Likewise constant cell format change to "date" from the example beyond, this is another thing that pisses me off in Excel. And after years of suffering from this I decided to try my luck here.

In case you wonder, I am creating monthly progress tracker.

Book1
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP
1	OCT	🚀		Tu	We	Th	Fr	Sa	Su	Mo	Tu	We	Th	Fr	Sa	Su	Mo	Tu	We	Th	Fr	Sa	Su	Mo	Tu	We	Th	Fr	Sa	Su	Mo	Tu	We	Th		Σ	🎯🚀	🎯🗓	🗓	formulas
2				1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31						start date	end date
3	task1	50%	-18	1	0	2	1	0	0	1	2	2	1	2	0	2	2	3	0	0	0	0	0	0	0	=	=	=	=	=	=	=	=	=		18	36	46	39%	1-Oct	31-Oct
4
5	task2	79%	-5	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	3	3	3	3	3	3	1	=	=	=	=	=	=	=	=		19	24	42	45%	17-Oct	31-Oct
6	task3	17%	-5	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	1	=	=	=	=	=	=	=	=		1	6	8	13%	23-Oct	31-Oct
7	task4	13%	-157k	0	##	0	0	0	0	0	0	44	##	##	##	=	=	=	=	=	=	=	=	=	=	=	=	=	=	=	=	=	=	=		22591	180000	232500	10%
8	task5	21%	-17	##	##	##	0	0	0	0	0	0	0	0	0	##	##	##	##	##	##	##	#	##	0	=	=	=	=	=	=	=	=	=		4.6	21.6	37.2	12%
Sheet1

Cell Formulas
Range	Formula
C3,C5:C8	C3	=AK3/AL3
D3,D8,D5:D6	D3	=AK3-AL3
E3,N3	E3	=1
G3,L3:M3,O3	G3	=2
H3	H3	=1+9/60
K3	K3	=45/60
Q3	Q3	=1+37/60
R3	R3	=1+45/60
S3	S3	=2+40/60
W3:Y3	W3	=0
AK3,AK5:AK7	AK3	=SUM(E3:AI3)
AL3	AL3	=2*NETWORKDAYS(AO3, TODAY())
AM3	AM3	=2*NETWORKDAYS(AO3,AP3)
AN3,AN5:AN8	AN3	=AK3/AM3
D7	D7	=(AK7-AL7)/1000
AL5:AL6	AL5	=3*(TODAY()-AO5+1)
AM5	AM5	=3*DAYS(AP5,AO5)
AM6	AM6	=1*DAYS(AP6,AO6)
AL7	AL7	=7500*DAY(TODAY())
AM7	AM7	=7500*31
AK8	AK8	=SUM(E8:AI8)/1000
AL8	AL8	=900*DAY(TODAY())/1000
AM8	AM8	=1200*31/1000
E8	E8	=300+300
F8	F8	=400
G8,V8,Y8	G8	=200+200
Q8:T8	Q8	=200
U8	U8	=300+200
W8	W8	=200+200+200
X8	X8	=200+300

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C3,C5:C8	Cell Value	between 95% and 100%	text	NO
E6:AI6	Cell Value	=1	text	NO
E5:AI6	Cell Value	=0	text	NO
E5:AI6	Cell Value	="N/A"	text	NO
E5:AI5	Cell Value	=3	text	NO
E5:AI5	Cell Value	between 1 and 2	text	NO
C3,C5:C8	Cell Value	between 85% and 95%	text	NO
D3,D5:D8	Cell Value	>=0	text	NO

 

[Joe4]

I am failing to understand what the issue is.

Based on the example you posted, can you explain what is not working the way you want, and what exactly you want to happen in this case?
Remember, while you are very familiar with your problem and what you are trying to accomplish, we are not. All we know is what you decide to share with us.
So please be as detailed as possible in explaining what your issue is and what your desired result is.

 

[msword]

@Joe4 The "problem" is already been solved by your previous responses. It lies in the field of basic Excel function formatting and has little to do with actual task I am trying to accomplish. Sample is given just to satisfy curiosity, but not to help understand the problem better.