I am trying to build a formula that sums a column of shares owned based on the date in which the shares were purchased. I need the formula to subtract the date the shares were purchased from today's date and if that is greater or equal to 365, add the corresponding number of shares purchased. My current formula is... =SUMPRODUCT(SUMIF(B3:B32,TODAY()-B3:B34&">="&365,H3:H32))... however it is reading zero even though there are 18 dates that qualify. Thanks in advance for the help!
Bookmarks