This post requires no response. I've had a problem for a while that I've finally solved and I thought I'd post about it to save others wasted time.

The problem was that sometimes I'd try to enter a formula into a cell that had already been used as a date field with the intent to calculate something entirely different for that cell. But the formula wouldn't calculate, despite being displayed properly in the formula bar and as if it were text in the cell itself.

The only way I could ge this to work was to go to a fresh column, enter the formula and then cut/insert the column next to the column I'd tried to get to work and then delete the column I couldn't get to work.

Well, it turned out to be a formatting problem.

Solution, use the Edit, Clear, All command in the cell before trying to enter another formula. That clears pre-existing formulae and you can proceed.

LongFisher