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!
--
Regards Bill
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
