The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
36 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?
-1
votes
0answers
35 views

How to create a weekly report that takes values from another sheet which has monthly values in Google Spreadsheets

First things first. Here is the link: https://docs.google.com/spreadsheets/d/1u3-U9aHXHzZmWGWKXpaToHvJmtYFmSxUItZ3pgfgz9E/edit?usp=sharing Problem: I need the cells E29:E43 in the table in "Weekly ...
-1
votes
0answers
17 views

automatic date filling in column B when column A has a value in Google Spreadsheets [duplicate]

What function I need to choose so that when in column A I enter a value , the date in column B to fill automatically ? I tried to do this : B2==if(istext(A2),today(),"") The problem is I the date ...
1
vote
1answer
20 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 ...
1
vote
2answers
63 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: ...
2
votes
1answer
153 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
60 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 ...
1
vote
1answer
100 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 ...
3
votes
3answers
2k 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?
0
votes
1answer
623 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
132 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. ...
2
votes
2answers
971 views

Google Spreadsheets date and time format

I have lots of dates in the first column in the format August 23, 2010 at 11:01PM I was wondering if anyone knows a way to get them formatted in a way that I can then use for date and time ...
0
votes
1answer
1k 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 ...
1
vote
1answer
174 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 ...
9
votes
3answers
8k 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
94 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?
1
vote
1answer
247 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 ...
2
votes
1answer
756 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, ..., ...
1
vote
1answer
2k views

Is it possible to see the date/time for a Google Drive folder for the most recent add/modify/delete time/date of something within it?

Is it possible to see the date/time of the item that was most recently changed within a Google Drive folder, without having to find that item within the folder first? When browsing Google Drive in a ...
4
votes
2answers
8k 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 ...
7
votes
2answers
831 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 ...
2
votes
1answer
705 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 ...
1
vote
0answers
223 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 ...
3
votes
3answers
5k 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 ...
4
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 ...
4
votes
3answers
15k 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 ...
3
votes
2answers
6k views

How to extend series of dates in Google Docs?

I can fill series of other types just like in MS Excel by extending column downwards, even if formula applied. But I can't extend series of dates. I succeeded few times, but usually I'm getting ...
4
votes
1answer
1k views

Normalizing and grouping dates in Google Spreadsheet

I have a spreadsheet pulling together various readings taken of hours heater has run, electricity units use for that period, and outside temperature. For the last 3 months, the electricity usage and ...
1
vote
1answer
775 views

Recommended date format for REST GET API [closed]

What's the recommended timestamp format for a REST GET API like this: http://api.example.com/start_date/{timestamp} I think the actual date format should be ISO 8601 format, such as ...
0
votes
1answer
166 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 ...
5
votes
1answer
377 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 ...
5
votes
2answers
248 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?
11
votes
4answers
7k 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 ...