William Case wrote:
Hi;
Spent several hours on this one. I am trying to set up some date
calculations and I can't even get started. I *have* worked a lot with
dates in the past.
I am trying to set up a series of titles include forward and past
meeting dates that occur every Monday (i.e. on Agendas). I would like
to use the DATEVALUE("Text") function in formulae. In place of "Text",
I want a cell reference (e.g. B5) which in turn has today's date TODAY()
formatted to MMM D, YY. The final formulae should be able to calculate
various Agenda Dates 7 days apart, depending on independent conditions
which I can set up.
For now, I just have to get a base date value which I can manipulate. I
expected DATEVALUE(B5) to return 38937. Instead I keep getting errors.
Using single and double quotes doesn't help.
Help get me started on this, please? What am I doing wrong? Or, do you
have a better suggestion?
By now, I probably have my brain stuck in double-think loop and can't
break out!
TODAY() returns a number of days since null-date, which is 1899-12-30 by
default (see Menu:Tools>options>Calc>Calculation). Unfortunately this
number is shown formatted, even if the cell is unformatted. Change the
format of B5 to "00000" or use =N(TODAY()) in order to show the real
numeric value. DATEVALUE(dateString) expects a string as argument.
Simply use B5 rather than DATEVALUE(B5). Or use =N(B5) in order to see
the integer representation of B5. It makes no difference.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
