|
Trying to pull date from field getting error.
=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? |
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? |
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 |
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? |
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 |
dat*e*value, not dat*a*value try that. -- gearoi ------------------------------------------------------------------------ gearoi's Profile: http://www.excelforum.com/member.php...o&userid=26576 View this thread: http://www.excelforum.com/showthread...hreadid=401924 |
| All times are GMT +1. The time now is 07:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com