software

I am trying to use the Date Value function to convert a date to a
numeric value and I am getting #VALUE! error message. Any ideas why
this would be happening?

Drummer--
lmullenjr
------------------------------------------------------------------------
lmullenjr's Profile: www.excelforum.com/member.php...oamp;userid=33132
View this thread: www.excelforum.com/showthread...hreadid=529429Hi!

Explain how you are using it.

Datevalue( ) takes a TEXT argument. If you try to use a numeric argument
you'll get #VALUE!.

Biff

quot;lmullenjrquot; gt; wrote
in message ...
gt;
gt; I am trying to use the Date Value function to convert a date to a
gt; numeric value and I am getting #VALUE! error message. Any ideas why
gt; this would be happening?
gt;
gt; Drummer
gt;
gt;
gt; --
gt; lmullenjr
gt; ------------------------------------------------------------------------
gt; lmullenjr's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33132
gt; View this thread: www.excelforum.com/showthread...hreadid=529429
gt;

I am using it in a SumIf equation to sum up data within a range of
dates. I thought I could use the Date Value function, but the actual
dates are numeric, not text. Any suggestions?--
lmullenjr
------------------------------------------------------------------------
lmullenjr's Profile: www.excelforum.com/member.php...oamp;userid=33132
View this thread: www.excelforum.com/showthread...hreadid=529429Suppose you have a list of dates in column A, A1:A10. In column B, B1:B10
are some sales figures:

4/1/2006...............300
4/2/2006...............744
4/3/2006...............818
4/4/2006...............522
4/5/2006...............900
4/6/2006...............312
4/7/2006...............444
4/8/2006...............777
4/9/2006...............602
4/10/2006.............788

You want to sum up the amounts between 2 dates, say, 4/1 to 4/5. Try any one
of these:

=SUMIF(A1:A10,quot;gt;=4/1/2006quot;,B1:B10)-SUMIF(A1:A10,quot;gt;4/5/2006quot;,B1:B10)

=SUMPRODUCT(--(A1:A10gt;=--quot;4/1/2006quot;),--(A1:A10lt;=--quot;4/5/2006quot;),B1:B10)

=SUMPRODUCT(--(A1:A10gt;=DATE(2006,4,1)),--(A1:A10lt;=DATE(2006,4,5)),B1:B10)

Better to use cells to hold the date criteria:

D1 = 4/1/2206
E1 = 4/5/2006

=SUMIF(A1:A10,quot;gt;=quot;amp;D1,B1:B10)-SUMIF(A1:A10,quot;gt;quot;amp;E1,B1:B10)

=SUMPRODUCT(--(A1:A10gt;=D1),--(A1:A10lt;=E1),B1:B10)

Biff

quot;lmullenjrquot; gt; wrote
in message ...
gt;
gt; I am using it in a SumIf equation to sum up data within a range of
gt; dates. I thought I could use the Date Value function, but the actual
gt; dates are numeric, not text. Any suggestions?
gt;
gt;
gt; --
gt; lmullenjr
gt; ------------------------------------------------------------------------
gt; lmullenjr's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33132
gt; View this thread: www.excelforum.com/showthread...hreadid=529429
gt;