if the date
 

=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

if the date
 

Hi Jack

Will this do in G8?

=IF(E8<"",INT(E8),"")

Regards
Peter A

"jack" wrote:

=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