problems adding days to a date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carys - 12 Jul 2006 21:18 GMT

Hi,

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

Any clue?

Signature

Carys

Reply to this Message

Nick Hodge - 12 Jul 2006 21:23 GMT

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)

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

> Hi,
>
> I have a field that sums a date plus 14 days and I am getting some very
> strange results.
>
> Any clue?

Reply to this Message

Don Guillett - 12 Jul 2006 23:33 GMT

any formula?

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Hi,
>
> I have a field that sums a date plus 14 days and I am getting some very
> strange results.
>
> Any clue?

Reply to this Message

bpeltzer - 13 Jul 2006 01:21 GMT

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.

> Hi,
>
> I have a field that sums a date plus 14 days and I am getting some very
> strange results.
>
> Any clue?

Reply to this Message