Thanks works great now, dont know why I did not think off that. One more
thing, in a different column I am using

=MAX(SUM($F$4:F6)-50,0)

I also want this to show up on the same days as the other. Do you know how I
would do that? Can I use two formulas in a cell? If so, how?



"uturnabout" wrote:

you need "<=" not "<" to get today to show up today.

"Kevin" wrote:

I would like todays date to show up also, I am using this formula

=IF(A6<TODAY(),J6+329.23,"")

It is working, but today does not show up until tomorrow.

Thanks

Kevin