Home

excel formula

Highlighted
Tonya Sykes-Boyd
Occasional Visitor

I have an excel formula that is working in one spreadsheet but not in another. In the 082018 tab the formula is working but not in the 052018 tab. The formula's are in Columns E-O.

1 Reply

Hi Tonya,

 

Since in the latest sheet in column AK you have dates entered as text. You may check with formula like =AK1088+1 which returns error.

 

To convert text to dates select the column and on ribbon Data->Text to Columns, on third stage of the wizard select Date and MDY.

 

Perhaps some other columns as well are texts instead of dates/numbers, I didn't check all of them.

Related Conversations
Copy/paste no longer working in Excel
Jon Firooz in Excel on
69 Replies
Date Formatting in a Pivot Table
Lorrie Griffin in Excel on
3 Replies
Security Warning: Automatic update of links has been disabled.
Mark Adams in Excel on
6 Replies
EXCEL DO NOT SHOW GRAPH MAP CHART
Mark 777 in Excel on
49 Replies