Mar 25, 2023
Is there a function that returns a creation date?
In Google Sheets, I'm making a mileage log for tax purposes. See image. There are two columns, first column is the date the mileage was performed, the second column is the number of miles. Currently, I have this in the date cell:
=if(B3>0.1,today(),"") where B3 is the mileage cell
It returns today's date in the date cell. I came in the next day and the cell changed to today's date (duh?) So that doesn't work. I need the date to stay the date it was created.
Thank you for any help you may give me!
Dan
Rochester Hills, MI
Details
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
All Replies (2)
Mar 25, 2023
(where in Rochester Hills MI Dan?)
You have a couple of options to make the date static as of the date of entry ...
1) explore doing it with Google Apps Script
or
2) using native spreadsheet functions,
create a helper cell F2 as a dropDown with the following formula
=today()
use Data Validation for cells A2:A with criterion as DropDown (from a range)
cell F2
This way whenever you make an entry in a cell of column A, current day's date will be entered and will remain static
Last edited Mar 25, 2023
Mar 25, 2023
Hi Yogi,
Thank you for the quick response... :)
I live near Crooks and Auburn Rd. Do you live around here?
I work with a guy named, Anurag Anand, any relationship?
Ok, I don't know how to do script, so I chose option number 2. It is set up, after midnight tonight I'll confirm that it works.... (fingers crossed)
Dan
Mar 26, 2023
Now Let Us keep Googling.
By the way I don't know Anurag Anand
but I am pretty close to you -- around Crooks and Avon Road.
Cheers!
Yogi Anand