Formula Won't Calculate

[Todd Bardoni]

=NETWORKDAYS(DATE(YEAR(TODAY()),MONTH(TODAY()),1),TODAY()-1)

This formula won't calculate on its own. Hitting F9 does not work. I have to enter into edit mode in the cell with this formula and hit enter. I have calculation set to automatic.

Anyone ever hear of something like this?

 

[Oaktree]

Are you sure it's formula specific? Try using find and replace to replace = with =...That seems to fix the F2--> Enter oddity like you're describing.

 

[Todd Bardoni]

What do you mean formula specific? Its recognized as a formula and will calculate but only when I enter in and out of edit mode.

Strange issue...