Hi,
I have a field that sums a date plus 14 days and I am getting some very
strange results.
Any clue?
--
Carys
Hi,
I have a field that sums a date plus 14 days and I am getting some very
strange results.
Any clue?
--
Carys
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
[email protected]HIS
"Carys" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I have a field that sums a date plus 14 days and I am getting some very
> strange results.
>
> Any clue?
> --
> Carys
any formula?
--
Don Guillett
SalesAid Software
[email protected]
"Carys" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I have a field that sums a date plus 14 days and I am getting some very
> strange results.
>
> Any clue?
> --
> Carys
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:
> Hi,
>
> I have a field that sums a date plus 14 days and I am getting some very
> strange results.
>
> Any clue?
> --
> Carys
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks