Excel and date Tags: Office Excel Apps Last response: July 12, 2011 3:09 PM in Applications Share kath99 July 12, 2011 8:36:50 AM Hello, When using Excel I have my cells formatted as dd, when I add 31+7 is gives me 38 instead of 07 Thanks More about : excel date hang-the-9 July 12, 2011 3:09:16 PM Make sure that cell you are in is the same format as the others. I just tried in Excel 2003, when I used the formula =31+7 got 07 no issues. Maybe check to make sure you have the latest service pack. Can't find your answer ? Ask ! Publish Related resources: ForumExcel Date Question ForumExport date book to excel ForumExcel Header Date ForumExcel Date Help ForumHow to retreive an overwritten excel 2007 doc ForumExcel problem ForumI can\'t edit my excel sheets in my blackberry ForumExcel models - new build ForumExcel files not update when transferred ForumRecover overwritten excel files ForumNeed build advice - i7 data cruncher for massive excel sheets ForumExcel Property Differences ForumExcel 2007 jpeg hyperlink problem Forum1.8k-2k 1st build (graphics, gaming, large excel files) ForumMicrosoft office 7 - formatting merge fields in Word to import Excel worksheet ForumWhat is the difference between Extended and normal version of a software? ForumExcel 07 worksheet focus macro ForumExcel Formula Forum[Solved] Excel help ForumExcel help More resources Read discussions in other Applications categories Graphics Internet Applications Multimedia Office Security CAD Distributed Computing Drivers Enterprise Software Firmware Programming Photoshop Skype Wordpress !