Formula Won't Calculate

Todd Bardoni

Well-known Member
Joined
Aug 29, 2002
Messages
3,042
Code:
=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?
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,988
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

Well-known Member
Joined
Aug 29, 2002
Messages
3,042
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...
 

Watch MrExcel Video

Forum statistics

Threads
1,118,226
Messages
5,570,990
Members
412,353
Latest member
SofiaV
Top