Is it a TEXT result or number or date result. You need TEXT. And is the calculation stored?
Wow, it works! Using TEXT or Numbers all works. Thanks for your quick help!
1 of 1 people found this helpful
To address your first question, the format in which you enter dates is set by your operating system. So it sounds like your operating system is set to use the US standard of m/d/yyyy.
If it changes to d/m/yyyy when you click out of the field, custom data formatting has been set for the field in layout mode. To remove this, enter layout mode, select the field and look under "Data Formatting" in the inspector. Change it to "As Entered".