View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Nick Hodge Nick Hodge is offline
external usenet poster
 
Posts: 1,173
Default problems adding days to a date

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
HIS


"Carys" wrote in message
...
Hi,

I have a field that sums a date plus 14 days and I am getting some very
strange results.

Any clue?
--
Carys