Again, please don't try to use a function like DATEVALUE without reading in
Excel help what it does.

Help gives a crystal clear description of what the function does, what the
syntax is, and gives examples. Do please read it, and if there is something
specific in there which you don't understand, please come back to us with a
specific question. The help also has a "See also link" to other date and
time functions within Excel.
--
David Biddulph

"EMW103" wrote in message
...
Don, I had spent several hours going through the help menu. This suggests
that I'm looking to insert the date, which I'm not: I've got dates
inserted
manually, I'm trying go come up with a formula that recognizes those dates
as
part of an equation. I tried this: =IF(Q10=DATEVALUE, P10), but also no
luck. Any thoughts?

"Don Guillett" wrote:

Look in the help index for DATE. Then look for TODAY

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"EMW103" wrote in message
...
Why doesn't this formula work? =IF(Q11=DATE, P11). Can you not use a
date
as part of a calculation or question, and if not, what alternative
would
be
recommended?

The idea is: The formula I want is to copy cell P11 into cell R11 if
there's
text/data(which in this case is a date) in cell Q11. Is there
something
other than DATE that I could use?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc