Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding days to a date - changed in Excel 2010
Hello,
I've just upgraded to Office 2010 from 2007. I have a spreadsheet I use regularly which has a date column. In Excel 2007 I could change the dates in the date column by copying a value from a cell e.g. 31 and the using Paste Special-Add on the date cells. This would add 31 days to the dates in the cells. This doesn't work the same in Excel 2010. If I try the method above I'm left with a value of 31 in the cells. Can anyone help with how I should be adding values to a date in Excel 2010? Thanks Glenn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to subtract 60 days from a date (05/25/2010) 2003excel | Excel Worksheet Functions | |||
Adding days to a date cell to get a new date | Excel Worksheet Functions | |||
Adding 28 days to a date | Excel Discussion (Misc queries) | |||
Adding # of days to a date | Excel Worksheet Functions |