The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
2answers
22 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
66 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
0answers
5 views

How do I calculate the first Monday of next year in Excel? [migrated]

I need a formula to calculate the first Monday next year (or first Tues, Weds, Thurs, etc.) based on the date in cell A1. So for instance, if the date in cell A1 happens to fall on a Thursday, ...
1
vote
1answer
42 views

Date Formatting for Deadlines

I have set up a Google spreadsheet for managing projects and due dates, and I need to apply the following formatting to a column of dates, but I'm not sure how: Dates more than 7 days from today: ...
0
votes
1answer
223 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
0answers
56 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
630 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
464 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
160 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 ...
0
votes
0answers
121 views

How to get the timestamp / datestamp for each album in a Facebook profile?

Is there a browser plug-in or otherwise to get a listing of facebook albums with the date created / last updated for each of the albums? Background I am working on building a personal site for a ...
8
votes
2answers
4k 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
78 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
205 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
679 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
1k 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
6k 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 ...
6
votes
2answers
701 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
493 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
194 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 ...
2
votes
0answers
63 views

Date posting on Fitocracy workout

I log my workouts on the same day that I do them - part of my post workout ritual. I've noticed that when I've looked back over the postings that the dates are not the same as the days I logged them ...
3
votes
3answers
4k 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
1k 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
13k 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
4k 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
719 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 ...
2
votes
1answer
2k views

How can I list MediaWiki users added by date?

The Special:ListUsers page allows me to view all the users in MediaWiki. Is it possible to view them by date added? (I'm sure I've done this before, but maybe it was via an extension.)
0
votes
1answer
158 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
972 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
338 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
216 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
6k 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 ...