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
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 ...
2
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 ...
6
votes
1answer
17k views

How do I make a cell highlighted if the date in the cell is today? [duplicate]

Possible Duplicate: Advanced date logic in Google Spreadsheets I have a spreadsheet with many consecutive days. So Cell1 = 7/30/2012, Cell2 = 7/31/2012 etc. I want Cell1 to be highlighted if ...
5
votes
1answer
8k views

How do I change date format at top of day in Google Calendar?

I can change the date format for most dates displayed by my calendar to Irish format, however I can’t find how to change this one. The dates at the top of each day are shown as 5/17 or Month/Day—as a ...
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 ...
0
votes
1answer
247 views

Entering local date on Google Sheets

If I use the shortcut CTRL+; the date that is pasted is the server date. I have changed the settings so my Time zone is selected to my local time. Shouldn't my local time get pasted as opposed to the ...
2
votes
3answers
2k views

Pre-fill a cell with today's date

I would like a certain cell of mine to display today's date when I starts a new row. Is it possible?
5
votes
1answer
957 views

Search Engine that will return results based on date

Is there a way to use a search engine, preferably Google, that will yield results based on a date? For example, I would like to search on a term and only return results as if I was searching for that ...