Formula Error

[JOEE1979]

Not sure whats happening
but when I put yesterdays day as start and todays date as finish, the result is "Same day"

Thank you

Schedule 4 Tracker - Copy12313.xlsx
	H	I	J	K
6	Actual Start	Actual Finish	Expiry Date	Duration (days)
7	30-Oct-24	31-Oct-24	31-Jan-24	SAME DAY
2024

Cell Formulas
Range	Formula
J7	J7	=G7+30
K7	K7	=IF(IF(COUNTA(H7,I7)<>2,"",DAYS360(H7,I7,FALSE))=0,"SAME DAY",(IF(COUNTA(H7,I7)<>2,"",DAYS360(H7,I7,FALSE))))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
K7:K15	Cell Value	<=-1	text	NO

Cells with Data Validation
Cell	Allow	Criteria
H7:I7	List	='Current Month'!$AL$26:$AL$29

 

[StephenCrump]

Not sure whats happening ....

There's no mystery here. Your formula returns "SAME DAY", because DAYS360(H7,I7)=0 in this case. What result were you expecting to see using DAYS360?

By the way, you could shorten your formula to:

=IF(COUNT(H7,I7)<>2,"",LET(d,DAYS360(H7,I7),IF(d=0,"SAME DAY",d)))

 

[JOEE1979]

There's no mystery here. Your formula returns "SAME DAY", because DAYS360(H7,I7)=0 in this case. What result were you expecting to see using DAYS360?

By the way, you could shorten your formula to:

=IF(COUNT(H7,I7)<>2,"",LET(d,DAYS360(H7,I7),IF(d=0,"SAME DAY",d)))

Thanks, BTW, I got that formula straight from a premade calendar in excel