I need to calculate the difference in days between today and a set date allowing also negative differences.

Basically it's the shipping date for each order and how many days we have left till each shipping date or how many days we are running late once the shipping date has passed.

With datediff it stops counting once today is bigger than the shipping date.

1 Answer 1


Have you tried substracting both values? You could format it as number if it shows like a date in year 1899.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.