Auto inputting date

[Treecko]

Hi All
This my seem trivial to some but as a newbie I'm trying but frustrated trying to get it correct. I'm trying to auto input a date when I enter a final approved amount. The formula I am trying to use is =IF(MOD(H5,1)="$",THEN(J5=TODAY())) and I seem to not be getting it right. Any help would be appreciated.
I upload a excell sheet to help explain myself.
Regards

[wjk221]

You do not need a then statement
=IF(H5<>"",TODAY(),"")

That would be the formula that if H5 has a value in it, it would put the date in the cell and make sure the cell is in date format!

[alansidman]

Will column H only have a value in it if it is approved?

[Olly]

Two issues:

1. What criteria determines the date being entered into column J? Your currently formula tries to use MOD, but makes no sense.
2. The TODAY() function will change the date in that cell every day. Is this what you want, or did you want to paste a date value into column J?

[Treecko]

Thanks All for your help. WJK221 your formula work great and yes alansidman you are correct as I only require the date to be entered once the approved amount is entered.. OllyXLS thanks your your input as I am still trying to figure the formuals out by looking at other posts in the forum so I don't have to bother any one. It gets frustrating when every time I try and enter a formula it keeps coming up error!
Get up the great work
Regards ALL

[Treecko]

Thanks All for your help. WJK221 your formula work great and yes alansidman you are correct as I only require the date to be entered once the approved amount is entered.. OllyXLS thanks your your input as I am still trying to figure the formuals out by looking at other posts in the forum so I don't have to bother any one. It gets frustrating when every time I try and enter a formula it keeps coming up error!
Get up the great work
Regards ALL

[Treecko]

Sorry for the duplicate line