DATE PROBLEM

Article View: comp.apps.spreadsheets

Article #412

Back to comp.apps.spreadsheets Previous Next

#412

From: Babage International Ltd.
Date: Mon, 06 Sep 1999 00:00

22 lines
1371 bytes

I'm trying to count days from a specific date.

I use cell B1 as the TODAY() cell, and A1 as the date cell. The formula in
B1 is =TODAY -A1

B1 shows 36402 for August 30th 1999 with no data in A1 - OK

If I enter a numeric value in A1, (ie 122345) fine, B1 shows a reduced
number of days.

However if I input a date in date format - I.e. 20/08/99, B1 shows #VALUE.

Ive tried inputting the date in every conceivable format but it still shows
#VALUE

Ive changed the date format in Windows, but still the same, what am I doing
wrong?


Why?

I've alsotried reformatting the A1 cell with no effect.

Technical Details

Message-ID: <936639505.25338.0.nnrp-13.c1ed92cb@news.demon.co.uk>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f75a7,fd776f4812b29140,start
X-Google-Attributes: gidf75a7,public
X-Google-Thread: f5951,fd776f4812b29140,start
X-Google-Attributes: gidf5951,public
From: "Babage International Ltd." <Sales@Babage.com>
Subject: DATE PROBLEM
Date: 1999/09/06
Message-ID: <936639505.25338.0.nnrp-13.c1ed92cb@news.demon.co.uk>
X-Deja-AN: 521761816
X-NNTP-Posting-Host: babage-ltd.demon.co.uk:193.237.146.203
X-Trace: news.demon.co.uk 936639505 nnrp-13:25338 NO-IDENT babage-ltd.demon.co.uk:193.237.146.203
X-MSMail-Priority: Normal
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Newsgroups: comp.apps.spreadsheets,fj.comp.applications.excel
X-Complaints-To: abuse@demon.net