Does anyone know how to create new functions?

I am trying to write a formula that will return the Date Modified for another cell. Does anyone know how to do this?

I tried entering the formula =IF(C2="Complete", TODAY(), "")
but that only returns me todays, date and not the date that I marked my task as complete.

Can anyone help? :)