Issue with calculating days between two dates - returns #INVALID OPERATION
I have a column Start Date - that is formatted as a DATE column type
Then I have a TENURE column - that is formatted as a TEXT/NUMBER column type
In the TENURE column I am using the formula;
=TODAY() - [Start Date]@row
This formula used to work fine for me - but more recently when I log into the sheet it now returns an invalid operation error on me.
Anything I am doing wrong here?
Help Article Resources
Check out the Formula Handbook template!