#1
|
|||
|
|||
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!! |
#2
|
||||
|
||||
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 |
Tags |
calculated column formula, error, excel 2010 |
|
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 |
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 |