Questions tagged [date]

Reference to a time interval of one day during a month and year. Not to be used for the 'social engagement' meaning.

Filter by
Sorted by
Tagged with
75
votes
4answers
187k views

Is there a way to insert today’s date into a Google Docs?

I've looked under insert > ...? but couldn't find anything. Can this be done via an inbuilt function or a custom script?
10
votes
6answers
53k views

Advanced date logic in Google Spreadsheets

I have the folowing situation: Today is 4/9/12. I have a cell with a date in the sheet that is 4/13/12. This cell should turn red since it is within 7 days from the current date. What is a ...
4
votes
1answer
5k views

Insert current date to cell based on content in other cell

Background: I am trying to create a sheet which tracks my costs on daily basis. Instead of entering the current date everyday, I want the sheet to store the current day based on the content I enter ...
9
votes
2answers
2k views

Analyse frequencies of date ranges

I have a Google Spreadsheets where I would like to compute occurrences of date ranges. I have a column date_utc+1 which contains almost random date data. What I would like to do is put the date ...
3
votes
1answer
6k views

Convert a date in Google Spreadsheet?

I have a Google Spreadsheet with a date row in UTC time, such as 12/6/2012 11:14:32 I want GMT+2 local time, so how can I convert the date in Google Drive? And, if not possible, is there a way to do ...
2
votes
1answer
2k views

Date format in spreadsheet (google doc)

I want to create spreadsheets to record the money I spend each year. Each file is named as Cost-2012, Cost-2013,...etc. Inside each file, there are in fact 12 sheets, which are named as 01, 02, ..., ...
2
votes
1answer
143 views

Google sheets recently changed American datetime format, how do I change it back?

Google sheets recently changed American datetime format, how do I change it back? It used to default to using "MM/dd/yyyy" but as of a couple weeks ago now when I enter a date it defaults to "MM/dd" ...