Next to the corresponding value in column A, type the date that contribution or withdrawal was made in column B. Use the "date" function so the program recognizes the values as dates.[9] In Excel, the date function is =DATE(Year,Month,Day). For example, if you made a contribution ...