I have a somewhat suitable formula to enter values based on multiple criteria into a worksheet from other worksheets in my workbook.
I would like to know if there is anyway i can use a cell reference to the dates i specified in row 1 of cashflow worksheet, rather than manually entering in the dates in the formula. This will help when i have to change the dates in row 1. I tried to enter C1 and D1 as "datevalue" to see if that would help...Please Login or Register to view this content.
Any suggestions are appreciated.
Bookmarks