Hello!!!
Regarding to the screenshot below. Manage to get the "Receive Date" automatically add the current time/date when any percentage value is trigger & have it fix that on the day.
=IF(AND(D5<>"Not Done",D5<>""),IF(E5="",NOW(),E5),"")

For the "Complete Date", manage to get it put the current time/date as well when the percentage value is "100%". But each time I open the excel file, it'll change to today time/date. =IF(D6="100%",NOW(),"")

Anyone expert can enlighten me? So that it'll stay to the first time/date I choose 100%?
Thanks!

Screenshot
tasktracking2.gif
http://imageshack.us/photo/my-images...tracking2.gif/

The excel data formula
http://www.mediafire.com/?9qwwv6bix9ex9w9