todays date

K

Kevin

I would like today’s 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
 
K

Kevin

Thanks works great now, don’t 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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

todays date 6
how do I get autodate to stay the date it was saved 3
Conditional Format (Todays Date) 2
Todays date 3
If cell is blank automatically enter today's date in the same cell 21
Conditional Format 3
conditional format 2
Automatically copy cells from two week day sheets based from today 0

Top