Originally Posted by
katja328
=IF(AND(F7>DATE(Year(F3),Month(F3),Day(F3)),(F7<Date(Year(F3),12,31)),-H12,0))
F3=Start Date - currently 6/1/09
F7=End Date
H12 = deposit amount 3000
Trying to get to the following:
If my End Date (F7) is between my start date (F3) and the 31st of December of the start date's year (Date(Year(F3),12,31) then put negative deposit in cell (-H12) otherwise put 0
the following year would the formula should be between the next year 1/1/10 (Date(Year(F3)+1,1,1) and 12/31/2010 (Date(Year(F3)+1,12,31) then return -H12 otherwise put 0
Thanks.
Looks like you have the paranthesis in the wrong place. There should be another ")" before the ",-H12" and only 1 afer the ",0"
And To make it easier to read why don't you do this:
Bookmarks