Date results showing up as #s

Microsoft Office excel 2007 - upgrade
May 12, 2010 at 08:19:14
Specs: Windows Vista
I figured out how to construct a formula that would add 7 days to a date from a previous cell. I am simply using =B2+7. My problem is that the results are showing as ###### instead of a date. When I mouse over the cell there is a "pop-up" type "comment box" with the correctly calculated date in it, so I know my formula is working. But I want the date to be in the cell. I can get the date in B2 to display properly if I change the date formatting to m/d/yy but otherwise it becomes ###### too...all the tutorials for date formulas make it look like the result should just automatically appear in the cell...HELP!

See More: Date results showing up as #s

Report •

May 12, 2010 at 08:30:33
Did you try expanding the column width?

Excel will display "negative dates" as ####, but if you are sure that the correct date is in the cell, it just might not be fitting in the cell.

Report •

May 12, 2010 at 08:52:13
OMG Thank you! Can you believe I racked my brain for hours over this and it was something as silly as that?? My first date was shown as 5/6/10 but when calculated the results had the entire year so the same size column wasn't enough! Yay!

Report •

Related Solutions

Ask Question