| 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? |
| 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) | |||
Threaded Mode
