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.

A date is the representation of a time period, usually of 24 hour duration. This can be absolute (eg 30 December 1899 CE, which happens to be what Google spreadsheets interprets for Day 0) or relative, such as "yesterday" or "tomorrow".

Calculations involving dates are usually based on date serial numbers, with different systems indexing dates from different reference points (UNIX time, the 1900 system, the 1904 system, Hijrah etc) but in each case one unit represents one day and fractions thereof are usually allowed. Hence a quarter of a day (0.25 units) would be 6 hours so, for Google Spreadsheets for example, 1.25 might be formatted to display 31/12/1899 06:00:00).

Given for instance July 4 2000 being 7/4/2000 “US” and 4/7/2000 “UK”, questions about dates should, preferably, specify which convention is being applied or, alternatively, use examples such as 2/2/2000 where there is no difference.

Where dates may be involved in any type of calculation the question should specify the data is a string (text format) when not the representation of a date serial number, unless that is obvious from the context.

76 questions
53
votes
4 answers

How can I search for Gmail messages on a particular date?

I'm searching for a message on or about a particular date and rather than scrolling through my emails to go back about a year, I'd like to know a search method to only find emails from a particular date or date range. How can I do this with Gmail?
WilliamKF
  • 3,374
  • 8
  • 29
  • 33
21
votes
5 answers

How to add a line break in a custom date format in Google Spreadsheets?

Google Spreadsheets give us a tool to create and use a customized data format for date values. While the tool allows us to use arbitrary characters, like slashes and commas between the date fields (day, month, day of week...), I fail to see how to…
bruno
  • 839
  • 3
  • 10
  • 21
20
votes
4 answers

How can I change Google Spreadsheets to have ISO 8601 dates as default?

I would love to set my default date format to be ISO 8601 (relevant xkcd) for all of my Google Spreadsheets. I'm well aware that I can manually change the date format for a given spreadsheet by: Selecting the whole sheet, click Format > Number >…
JBWhitmore
  • 953
  • 2
  • 7
  • 9
17
votes
6 answers

Advanced date logic in Google Spreadsheets

I have the following 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 way to use conditional formatting to get Google…
Andrew Davis
  • 323
  • 2
  • 3
  • 7
10
votes
1 answer

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

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 today is 7/30/2012 and Cell2 to be highlighted if today…
daviesgeek
  • 857
  • 4
  • 15
  • 24
9
votes
2 answers

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 values into bins of six hours each, i.e., 12/5/2012…
grssnbchr
  • 271
  • 4
  • 8
7
votes
1 answer

Trying to subtract X days from a defined date in Google Sheets

I'm trying to figure out "how to" subtract days from a date in Google Sheets. EXAMPLE Col A (original date) Col D (date - 5 days) 08-08-16 08-03-16 A1 will display the original "date" and D1 will have a "formula" that…
Mr. B
  • 2,967
  • 11
  • 38
  • 46
7
votes
2 answers

Automatic date in Google Docs

Is there a way in Google Docs to automatically update the date in a header of the page, so that whenever I print the document it will have today's date?
Christian
  • 1,505
  • 6
  • 15
  • 24
7
votes
1 answer

How to edit dates in Google Sheets as ISO 8601?

I know how to make Google Sheets display dates in ISO 8601 format (YYYY-MM-DD). Now, how do I make them not only display, but edit in the same format? See the edit line below: Moreover, if that is linked to a locale in use, which one would have a…
sanmai
  • 266
  • 1
  • 6
6
votes
1 answer

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 term back in the year 2005. The results should…
spong
  • 828
  • 2
  • 9
  • 17
5
votes
1 answer

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 in the Costs column. For the cells in column C I…
5
votes
1 answer

How can I use Google Spreadsheet to format Date in DD/MM/YYYY format?

First thing's first: my spreadsheet's locale is properly set to UK: If I paste in the following date: 30/09/2013 21:15 Then click Format > Number > Date time Nothing changes. I also can't seem to sort by date.
mikemaccana
  • 257
  • 1
  • 4
  • 10
5
votes
2 answers

How to sort Trello cards by date added

Trello is rad. But one thing I haven't figured out: How to sort cards in a list by the date that the cards were added to the list (or to the board)? Also, is it possible to show (as a custom field?) the date that a card was added?
samthebrand
  • 5,499
  • 17
  • 56
  • 80
4
votes
2 answers

Google sheets MM-DD-YYYY to DD-MM-YYYY

I downloaded CSV data from my Etsy shop to calculate taxes. I'd like to have the date "copied" properly. The CSV date I get from Etsy is formatted as "02/09/16" This is "2 September 2016" in Dutch but "September 2 2016" in English. I cannot seem to…
Ramon
  • 41
  • 1
  • 2
4
votes
1 answer

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 European, I would like to be able to display…
Toby Allen
  • 691
  • 1
  • 10
  • 24
1
2 3 4 5 6