if the date

J

jack

=IF(E8="paid",B28-B8,B28-0) how do i write a formula for cell g8 so the date
(2/24/2008015:21 or any date pald )would show up in cell g8. try using =now()
the date shows up but e8 is blank or i got paid in e8.

what i would like is if=paid then date if not blank thx for any help
 

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

Top