How to change 0 day = 1 day

OK, Thank a lot

I applied your formula and it’s work !!

@Art_Cutecake
You can try with:

CEILING(
    HOUR(
        [end-date]-[start-date]
    )/24
)

OR

IFS(
    HOUR([end-date]-[start-date])/24 < 1,
    1,
    TRUE,HOUR([end-date]-[start-date])/24
)
3 Likes