Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-22-2014, 10:36 AM
amlevesq amlevesq is offline Inconsistent Calculated Column Formula Error Windows 7 32bit Inconsistent Calculated Column Formula Error Office 2010 32bit
Novice
Inconsistent Calculated Column Formula Error
 
Join Date: Apr 2014
Posts: 1
amlevesq is on a distinguished road
Default Inconsistent Calculated Column Formula Error

I'm hoping someone can help me figure out what's going on with my table. To preface everything...I am trying to copy formulas from a table on one Excel 2010 sheet to a table on another Excel 2010 sheet, within the same workbook.



I am trying to breakdown a column that contains a date (column heading is FormCreated) into 3 separate columns for the year, the month, and the day.

The first column uses the formula =YEAR([@FormCreated])...this works perfectly and gives me just the year.

The second column uses the formula =MONTH([@FormCreated])...this works perfectly and gives me the month number.

The third column uses the formula =DAY([@FormCreated])...this one generates the following error message: Inconsistent Calculated Column Formula. :-(

When I select the option within the error to Restore to Calculated Column Formula, it adjusts the formula to try and link to the previous sheet (which I don't want, as I will eventually delete the previous sheet)...so it becomes =DAY(Table_owssvr_4[@FormCreated]).

I'm at a loss to explain why the Day formula won't work, when the Year and Month work perfectly. Any help anyone can provide will be greatly appreciated!!
Reply With Quote
  #2  
Old 04-22-2014, 11:53 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Inconsistent Calculated Column Formula Error Windows 7 64bit Inconsistent Calculated Column Formula Error Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,505
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

Hi and welcome perhaps Copy - paste values to your new sheet then extract the data?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Tags
calculated column formula, error, excel 2010

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error handling in formula - suppress 'Syntax Error' Cosmo Word 7 02-24-2014 07:08 AM
column width error message norwood Word VBA 2 10-07-2013 05:05 PM
formula to work from data column masterdineen Excel 16 08-09-2012 07:52 AM
Inconsistent Calculated Column Formula Error formula divide by serio error vthomeschoolmom Excel 1 04-18-2012 02:29 PM
Formula not getting copied to entire column theacegary Excel 1 11-29-2010 02:18 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:26 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft