| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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? |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Field Source Error for Pivot Table | Excel Worksheet Functions | |||
| Excel date field link to Word | Excel Discussion (Misc queries) | |||
| Automaticaly put in the / in a date field | Excel Discussion (Misc queries) | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
| Print Footer with Last Print Date field name | Excel Discussion (Misc queries) | |||
Linear Mode
