Evening All
Please can somebody help me?
I have made a budget spreadsheet.
In cell C139 I have todays date: =TEXT(TODAY(),"d mmm yyyy")
In column D (D140:D1171) I have a list of dates (formatted as Sun 6-Feb-2005)
In column AH I have a formula to calculate the total figure that I am going to spend on the date entered in column D. For example, the formula looks like this: =IF(AE390>0,AD390+AE390,IF(AF390>0,AD390-AF390,AD390))
I would like to write a formula in cell C140 that looks for the date in cell C139 in the list of dates in column D and reports back the corresponding amount of money in column AH that I have budgeted to spend for today. How do?
Thanks in advance!
Bookmarks