Date format doesn't work?

edit

You need to enter the date in a format that Calc will recognise as a date - starting with July causes Calc to interpret the input as text.

See sections 2 and 3 of this article for more information.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.