# Is there a google docs spreadsheet function for date recording?

**URL:** <https://boards.straightdope.com/t/is-there-a-google-docs-spreadsheet-function-for-date-recording/708709>\
**Category:** Factual Questions\
**Created:** [January 1, 2015, 8:44pm UTC](https://boards.straightdope.com/t/is-there-a-google-docs-spreadsheet-function-for-date-recording/708709 "2015-01-01T20:44:22Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bup](https://avatars.discourse-cdn.com/v4/letter/b/6bbea6/32.png) [@bup](https://boards.straightdope.com/u/bup)\
**Post date:** [January 1, 2015, 8:44pm UTC](https://boards.straightdope.com/t/is-there-a-google-docs-spreadsheet-function-for-date-recording/708709/1 "2015-01-01T20:44:22Z")

</div>

I use google docs for my ‘checkbook.’

I was wondering if there’s a function that records the last time another cell got edited. So dimply entering a credit or debit would cause the date to get recorded automatically in another column. Marking a column that a transaction cleared could also record that date.

---

<div class="post-metadata">

**Author:** ![Reply](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/reply/32/15952_2.png) [@Reply](https://boards.straightdope.com/u/Reply)\
**Post date:** [January 3, 2015, 5:16pm UTC](https://boards.straightdope.com/t/is-there-a-google-docs-spreadsheet-function-for-date-recording/708709/2 "2015-01-03T17:16:31Z")

</div>

You can do it with a script:

> <https://webapps.stackexchange.com/questions/37408/auto-updating-column-in-google-spreadsheet-showing-last-modify-date>

It’s probably easier to use purpose-built checkbooking software, though. Try Mint or YouNeedABudget.