Trying to pull date from field getting error.

[Bill R]

=IF(ISBLANK(Dec!E2),YTD!F12,(IF(ISERROR(SUM(((F32)/(DAYS360(DATE(2005,1,1),X1,FALSE)))*(360))*(F13)),"",(SUM((F32)/(DAYS360(DATE(2005,1,1),X1,FALSE))))*(360))*(F13)))

This is my formula, and it works but instead of entering the date (2005,1,1)
manually I want it to pull from cell (H2) but when I reference (H2) I get an
error message telling me that I have too many arguments. How can I make this
work?

[gearoi]

does 'datevalue (h2)' help?

It gets rid of the need to split up months and stuff.

Differences between datevalues give you the number of days.

[bj]

did you enter
....360(H2,X1...
or ...360(date(H2),X1...

Why are you using the ...Sum...


"Bill R" wrote:

> =IF(ISBLANK(Dec!E2),YTD!F12,(IF(ISERROR(SUM(((F32)/(DAYS360(DATE(2005,1,1),X1,FALSE)))*(360))*(F13)),"",(SUM((F32)/(DAYS360(DATE(2005,1,1),X1,FALSE))))*(360))*(F13)))
>
> This is my formula, and it works but instead of entering the date (2005,1,1)
> manually I want it to pull from cell (H2) but when I reference (H2) I get an
> error message telling me that I have too many arguments. How can I make this
> work?

[Bill R]

When I do as you suggest I get a message telling me that I am using too many
arguments. The SUM is being used because I need the sum of the formula.

"bj" wrote:

> did you enter
> ...360(H2,X1...
> or ...360(date(H2),X1...
>
> Why are you using the ...Sum...
>
>
> "Bill R" wrote:
>
> > =IF(ISBLANK(Dec!E2),YTD!F12,(IF(ISERROR(SUM(((F32)/(DAYS360(DATE(2005,1,1),X1,FALSE)))*(360))*(F13)),"",(SUM((F32)/(DAYS360(DATE(2005,1,1),X1,FALSE))))*(360))*(F13)))
> >
> > This is my formula, and it works but instead of entering the date (2005,1,1)
> > manually I want it to pull from cell (H2) but when I reference (H2) I get an
> > error message telling me that I have too many arguments. How can I make this
> > work?

[Bill R]

The last part of the formula dosen't work when I replace 'date' with
'datavalue'. There has got to be a way to code the formula to simple take the
'2005,1,1' from the H2 field and insert it into the formula. Any other ideas?


"gearoi" wrote:

>
> does 'datevalue (h2)' help?
>
> It gets rid of the need to split up months and stuff.
>
> Differences between datevalues give you the number of days.
>
>
> --
> gearoi
> ------------------------------------------------------------------------
> gearoi's Profile: http://www.excelforum.com/member.php...o&userid=26576
> View this thread: http://www.excelforum.com/showthread...hreadid=401924
>
>

[gearoi]

datevalue, not datavalue

try that.