NOW and DATEVALUE Function

  • Thread starter Thread starter Bryne
  • Start date Start date
B

Bryne

On a thirteen sheet spreadsheet, sheet one is "Today", and
sheets 2-13 are January-December. One cell on the "Today"
sheet is the current date -- =NOW(). Several of the other
cells contain daily information entries; I enter them into
the daily sheet, then tab to the monthly sheet and enter
them into a monthly dated column (e.g., January 1-31). I
would like to force the data entered into the "Today" sheet
to automatically populate to the appropriate cells in the
month sheets. I'm guessing that I'm going to have to use
something like "If DATEVALUE("NOW")of "Today" sheet
=DATEVALUE of Monthly cell, then populate cell of monthly
sheet with daily value. However, when I try any
permutation of DATEVALUE("NOW()"), I get "#VALUE". Any
suggestions?

Any help would be appreciated.

Thanks.
 
when I try any
permutation of DATEVALUE("NOW()"), I get "#VALUE".
Click to expand...

I would expect that.

DATEVALUE is looking for a TEXT representation of the date.

"NOW()", "NOW" are both TEXT that do not look like a date. They look like the
literal "NOW".

NOW() (no quote marks) does not return TEXT, rather it returns a number equal
to the number of days and fraction of a day since 12/31/1899 24:00:00

A text representation of the date might be something like "12/3/2003"

Also, if you enter a date/time or the =NOW() into a cell, unless the cell was
previously formatted as text, Excel will interpret your entry as a date (i.e. a
number as described above) and DATEVALUE again will give a #VALUE! error.

--------------------

Getting back to your original problem, I'm thinking that you will need to use
some kind of VBA routine to get the data from your entry sheet to the summary
sheets automatically. You might look into using forms for data entry.


--ron
 
Back
Top