How to connect date with expenditure

  • Thread starter Thread starter Prospero
  • Start date Start date
P

Prospero

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!
 
Change the formula in C139 to just:

=TODAY()

and format this cell whichever you like via Format|Cells.

Assuming that D140:D1171 houses true dates...

=SUMIF($D$140:$D$1171,C139,$AH$140:$AH$1171)

if there can be multiple occurrences of today's date in D.

Otherwise, if it can occur once in D...

=INDEX($AH$140:$AH$1171,MATCH(C139,$D$140:$D$1171,0))
 
Back
Top