The tag has no usage guidance, but it has a tag wiki.

learn more… | top users | synonyms

11
votes
6answers
18k views

Insert today’s date into a Google Document?

Is there a way to insert today’s date into a Google Document? I've looked under insert > ...? but couldn't find anything. Can this be done via an inbuilt function or a custom script?
2
votes
1answer
44 views

Cognito Form with Blackout dates and date functions

Is there a way to have "blackout" dates on my form? I rent equipment and when all equipment is rented out, I want to be able to black out specific dates.
4
votes
2answers
11k views

Facebook join date is hidden from timeline but still visible to public

I have already hidden the "Facebook join date" from my timeline (by hovering over it, selecting edit or remove (the pencil) and then Hide it from timeline). Right now, I cannot see this date if I go ...
5
votes
5answers
20k 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
2answers
10k views

How to Fill a Column with Sequential Dates in Google Sheets

In Excel you can right-click drag a date downwards to fill a column with the next dates in the sequence. For example if you enter 9/1/2014, select that cell, then right-click drag down over the cells ...
2
votes
0answers
84 views

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 ...
5
votes
1answer
464 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 ...
2
votes
1answer
48 views

Find the date of a Blogspot blog comment

I'm trying to find the date of comments on a Blogspot blog (which is not mine). Unfortunately, all that is listed is the time of the comment, but that information is useless without knowing what date ...
0
votes
1answer
100 views

How to turn cell yellow if date in cell is between 180 and 365 days in the past

In Google Spreadsheets how do I use conditional formatting to turn a cell yellow if the date is between 180 and 365 days in the past?
22
votes
3answers
35k views

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 ...
0
votes
1answer
562 views

List of Dates of Current & Previous Month in Google Spreadsheets

I want to have the dates of the current month and the previous month automatically get populated. So I'm using =MONTH(NOW()) to get the current month and =MONTH(NOW())-1 to get the previous month. ...
1
vote
1answer
298 views

Date format in Google Spreadsheet is not correct

Whenever entering the date e.g. day-month-year, it automatically changes to month-day-year. I went into format>number>more formats>more date and time formats, and I changed it to day-month-year. And ...
1
vote
1answer
334 views

Conditional formatting for dates in Google sheets

I work at a language school and I have a column giving the students expected arrival date. I want to set conditional formatting to: Highlight in red any date that is older than 1 week Highlight in ...
1
vote
2answers
153 views

Date autofill increments year instead of day

Earlier, when I had dates in a column like: Monday, 21 April, 2014 Tuesday, 22 April, 2014 and I extended the last cell to lower cells I could expect them to be filled with following days: ...
5
votes
1answer
2k 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 ...
2
votes
1answer
448 views

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

I would love to set my default date-setting 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: ...
2
votes
1answer
113 views

How to make my Google Spreadsheet automatically calculate “days since”

I have a spreadsheet with several columns and one of them is for date (column D). How do I make the next column (E) automatically display the days passed from date in D until now on open? I have ...
0
votes
1answer
2k views

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

Auto date added to adjacent cells when data is entered

I am trying to create a spreadsheet to track student loan outs that will automatically put the date in an adjacent cell. The spreadsheet would be set up like this: Column 1 would be "name" Column 2 ...
2
votes
1answer
1k 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 ...
4
votes
3answers
10k views

Google Spreadsheets: Add 3 hours to Date value (DD/MM/YYYY 00:00:00)

I have cells with dates in this format: DD/MM/YYYY 00:00:00 and I want to add 3 hours because I'm in a different GMT zone. Is possible to use dates in a formula? Something like: 30/12/2012 22:15:00 ...
0
votes
1answer
146 views

Google Sites File Attachment Date and Time

I live in the Central Time Zone. When I attach a file in my Google Site, it shows Pacific Time for the Attachment Time. Is there anyway to have it show Central Time?
0
votes
1answer
204 views

How can you google search for pages updated recently? [duplicate]

I seem to recall years ago google had a feature where you could search for pages updated "last year", "last month", "last week" etc. Especially when searching through forums, is there's away to filter ...
6
votes
2answers
320 views

Date criteria for Google search

Sometimes I'm looking for date-sensitive information and don't want to see results more than a certain age. Is there a way to specify this in a Google search?
12
votes
4answers
11k views

How can I find the creation date of a document in Google Docs?

I'd like to know when a document has been created, but Google Docs doesn't seem to display that information anywhere. I tried looking at the revisions, but all it displays is a relative time (2 months ...
2
votes
1answer
908 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, ..., ...
8
votes
2answers
1k views

Analyse frequencies of date ranges in Google Spreadsheet

I have a Google Spreadsheet where I would like to compute occurrences of date ranges. As you can see in my sheet, there is a column date_utc+1 which contains almost random date data. What I would ...
1
vote
0answers
271 views

How to Create a Dynamic SubTables Based On Data From Another Sheet? (Google Spreadsheet)

I'm wondering if there is a way to create a sheet with dynamic subtables based on data from another sheet in google spreadsheets? Each student will use a form to enter data to sheet: "Entries" like ...
0
votes
1answer
195 views

Entering Local Date on Google Doc 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 ...
5
votes
2answers
1k views

can I schedule to send mail later on with duration on gmail? [duplicate]

Possible Duplicate: Can I set an e-mail to send on a timer within gmail? I'd like to schedule an email at a later time and date with Gmail. Is this possible? They have many goodies in their ...