Trying to pull date from field getting error.

B

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?
 
B

bj

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

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

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
 
B

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.
 
B

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

First part of "IF" function returns false even if true. ?? 4
Formula problem 0
AND/OR FUNCTIONS 2
copy worksheet to another worksheet 2
formula to add year to date figures 0
Sub runs, but gives error when called. 7
trying to email workbook from VB6, getting error 1004 2
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) 0

Top