if you want yesterday's value to show until you enter today's try

=IF(VLOOKUP(TODAY(),A4:M186,13,FALSE)="",
IF(VLOOKUP(TODAY()-1,A4:M186,13,FALSE)<0,
VLOOKUP(TODAY()-1,A4:M186,13,FALSE),"")
VLOOKUP(TODAY(),A4:M186,13,FALSE),""),IF(VLOOKUP(T ODAY(),A4:M186,13,FALSE)<0, VLOOKUP(TODAY(),A4:M186,13,FALSE),"")



"Kevin" wrote:

Bernie

I after outing the formula in, nothikng apears in L3

BJ at the end of every day, todays date.

"bj" wrote:

at the end of which day?
the last day entered? today? November 14th?

"Kevin" wrote:

In A4 though A186 there are dates, May 16, 2007 €“ Nov 14, 2007. In Column M a
dollar amount that I enter every day. At the end of the day if the value in M
is a negative number, I would like L3 to show by how much.