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!!

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