Hi - I'm building a budget spreadsheet in which ...
Col B contains "DUE DATE", Col C "AMOUNT", and Col D "DESCRIPTION".
I need help in the way of a formular in cell J1 that will return the
date (from col B) of the next pay.
The next pay is denoted with "Pay" in col D, DESCRIPTION. That is, I
want the formula to look down col D (Description) for the first entry
"Pay" and return the date of that pay that appears 2 rows left in col
B.
Any help would be appreciated.
Regards, Kaye
Bookmarks