How to get current date?

I need to get current date and add to column in a Google Spreadsheet.

I dont receive the time and date info I need make to get it from the time it process the data.

How can I get the current time and date and insert that info on Google Spreasheet column?

Hi @Rafael_Chavantes,

There is a “now” variable in the “date & time” function area, which will give you the current date and time.


and if you want the date in a specific format, you can use formatDate(now; <format>) with the Date Formatting Tokens.

For more information, see