DATE PROBLEM

Thread View: comp.apps.spreadsheets

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Babage International Ltd. Mon, 06 Sep 1999 00:00

#412

Author: 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.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads