problems adding days to a date Carys 12.07.2006 20:18:02 Hi, I have a field that sums a date plus 14 days and I am getting some very strange results. Any clue? -- Carys

Re: problems adding days to a date "Nick Hodge" <nick_hodgeTAKETHISOUT[ at ]zen.co.uk.ANDTHIS> 12.07.2006 20:23:17 What have you got and what strange results are you getting If there is a 'true' date in A1 (01/01/2006) then =A1+14 will give you 15/01/2006 (UK dd/mm/yyyy) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk nick_hodgeTAKETHISOUT[ at ]zen.co.uk.ANDTHIS "Carys" <Carys[ at ]discussions.microsoft.com> wrote in message news:9695E500-67BA-407C-AF2F-3AEA692F37A2[ at ]microsoft.com... [Quoted Text] > Hi, > > I have a field that sums a date plus 14 days and I am getting some very > strange results. > > Any clue? > -- > Carys

Re: problems adding days to a date "Don Guillett" <dguillett1[ at ]austin.rr.com> 12.07.2006 22:33:06 any formula? -- Don Guillett SalesAid Software dguillett1[ at ]austin.rr.com "Carys" <Carys[ at ]discussions.microsoft.com> wrote in message news:9695E500-67BA-407C-AF2F-3AEA692F37A2[ at ]microsoft.com... [Quoted Text] > Hi, > > I have a field that sums a date plus 14 days and I am getting some very > strange results. > > Any clue? > -- > Carys

RE: problems adding days to a date bpeltzer 13.07.2006 00:21:02 Strange, like a number somewhere around 39000? If so, you just need to format the result cell. Either use Format on the menu bar, or copy the original date cell's format using the format painter. "Carys" wrote: [Quoted Text] > Hi, > > I have a field that sums a date plus 14 days and I am getting some very > strange results. > > Any clue? > -- > Carys