Age formula not working properly

[jcarot61]

To whom it may concern
Need help with age formula [ =IF(S13="","",DATEDIF(S13,TODAY(),"Y")) ] was working fine, but since yesterday, cannot get age unless I enter formula cell and hit ENTER or Save the document every time I enter a knew date. Even if I erase date from cell (as you can observe on line L21), I have to save document so that age that appears can be erased on it's own. Pls. assist, Thank you in advance for your help.

 

[Zyndstoff]

Sounds like you set your calculation to manual. Reset to automatic and it should work again.

 

[jcarot61]

Sounds like you set your calculation to manual. Reset to automatic and it should work again.
View attachment 51278

Thank you, seems everything working great now. May I ask, How in the world I managed to do such a thing, without knowing it? Thank you again.

 

[MARK858]

If you opened another workbook first that was set to manual calculation then all other workbooks that were opened afterwards would be set to manual