Hot answers tagged

40

You can use the before and after keywords in your search, for example: after:2012/4/26 before:2012/5/3 To search for emails between April 26, 2012 and May 3, 2012.


19

In the right hand side of the gmail search bar there is a drop-down arrow- click it. The drop-down includes a date range option, and you should be all set from there


16

All date/time values in spreadsheets are internally handled as floating point values. To add 3 hours to a date/time just add (3/24) to the original date/time. =F3+(3/24) This also works in MS Excel.


14

It’s possible to insert todays date through a macro. Open your Google Document and under Tools select Script editor. This opens Google's script editor where it’s possible to create macros for Google Documents. Paste this script and save it as Date Macro or something: (also available here) ** * The onOpen function runs automatically when the Google Docs ...


10

Yes. Use Conditional Formatting with three rules: (Format -> Conditional formatting) "Date is before" "in the past week" -> red "Date is after" in the past week" -> green "Date is" "in the past week" -> orange This will colour all dates more than a week away in green, all dates coming in the next week orange and the remainder of the dates in red. Empty ...


8

Go to Settings (Cog wheel on the upper-right side) Search for Date format Switch to 31/12/2012 Click Save at to the or bottom of the settings page


7

On Google: Do a search as usual Click on the Search tools option in the menu bar and then on Custom range Pick your desired date or type it into the To:-field Click on Go.


6

I think I've got the solution for you. It's not done all automatically, but it will result in your proposal: In your file the date is written as MM-DD-YYYY. I made the assumption that the date range covers december and NOT random dates throughout the year. Therefore I had to re-arrange the date format to DD-MM-YYYY. As a guidance I used the following ...


6

This is related to Is there any way to create a timestamp in a Google Spreadsheet? so my answer is similar to those, but adapted to your setup. Automatic insertion: requires Apps Script Use the following script (Tools > Script Editor): function onEdit(e) { if (e.range.getSheet().getSheetName() == 'Sheet1' && e.range.getColumn() == 4) { ...


5

The key is to enter at least the first two values to get auto fill to work with a pattern


4

Google recently updated the document revisions and they are displaying the exact date for each of them. For older documents it doesn't seem to be working, but at least all your new documents will be the way you wanted it.


4

Use the formula =IF([cell on same row in D column] <> "", today()-[cell on same row in D column], "") So in D2 (for example): =IF(D2 <> "", TODAY()-D2, "") TODAY() returns the current date. The current date minus the specified date equals the days passed between the dates. The code above means "If D2 is not empty set current cells value to ...


3

Use this to add the dates: Code function onEdit(e) { var aCell = e.source.getActiveCell(), col = aCell.getColumn(); if(col == 2 || col == 4 || col == 6) { var adjacentCell = aCell.offset(0, 1); var newDate = Utilities.formatDate(new Date(), "GMT+1", "dd/MM/yyyy kk:mm:ss"); adjacentCell.setValue(newDate); } } Example I've ...


3

Formatting is not the answer, because it doesn't affect the underlying values. You need to make the values updatable instead. One way is to make a reference-data place somewhere in one of your sheets (or maybe add a new sheet just for that), and put the year value in there. Then in the first cell where you want the date values to appear, use this ...


3

In MS Excel try this: =A1+TIME(2,0,0) Same with Google: =A1+Time(3,0,0) Adds 3 'Hours', 0 'Minutes', 0 'Seconds' to the date/time value of A1 Additionally if only you use the main sheet you can go into the sheet settings and change it's timezone accordingly.


3

Once you preform the Google search, you can click on More search tools and then Custom Range... This will use the publication date, which Google describes as: Limit results according to when they were published on the Web. Google tries to estimate the publication date for a page by using information such as the date when Google first indexed ...


3

Yes, you can. Go to Google's Advanced Search Page Expand the Date, Usage Rights, NumericRange, and More section Choose from the following options Past 24 hours Past week Past month Past year OR Do a regular Google Search Expand the Show Search tools on the left underneath the search field Choose from the following options. Before: These ...


3

At the bottom of most Blogspot posts you will find a link like the following: Subscribe to: Post Comments (Atom) When you click on that it will show you a code dump. It is the RSS feed for that particular post, including all the comments. All you need to then do is look for the comment you're interested in and then go to the first <published> ...


3

So you have something formatted mm/dd/yy, but your local format is dd/mm/yy. To recover the dates, you need Format the imported dates as plain text. Suppose these are in column A In column B, reconstruct the date in a less ambiguous format using regexreplace, and then use datevalue to turn it into a date. The column B should be formatted as a date. ...


2

Depending on the sharing status of the document, the Share/Publication date on the "Publish to the Web" menu under file can show an early date on the document. Revision history only goes back about a year.


2

The accepted answer mentions colours that are not mentioned in the question and only looks back. Also "Date is before" "in the past week" does not highlight dates within seven days of today. I suggest a Conditional formatting Custom formula is of the type: =and(A1>today()-7,A1<today()+7) where six days before today, today and six days after ...


2

If you open the document, you can view the revision history from the File menu. The oldest entry will be the original version, when you created it.


2

The solution is to set the correct Local under the Spreadsheet's settings ("This affects formatting defaults, such as currency."). So if you want US.locale style (MM-DD-YYYY), then choose US.Locale. If you are in a different locale and want formatting


2

The zero mark for date/time in Google Sheets is 12/30/1899 0:00:00, as you can see by entering 0 in a cell and formatting it as date/time. That said, sheets are mostly 1-based, so the idea here is that day 1 is the last day of 1899. Spreadsheets are designed for office workers, not for programmers. In an office, time is measured in days more often than in ...


2

To find the number that's halfway between A2 and B2, use the formula =(A2+B2)/2 (You'll need to apply a suitable date format to the output.)


2

Here is an easily customizable function for this purpose: enter the numbers of the column to watch and the column for timestamp on appropriate lines function onEdit(e) { var colWatch = 5; // column to watch, 5 = "E" var colRecord = 6; // column for timestamp, 6 = "F" if (e.range.getColumn() == colWatch) { e.range.offset(0, colRecord - ...


1

If you are willing to use a 3rd party program, I use Dash - http://kapeli.com/dash - with a Date and Time snippet. It auto replaces your snippet (mine is 'datetime') with the current date and time. This works system wide. Dash is only available for OS X and iOS.


1

This has now been resolved by Google Spreadsheets. Pasting in the date: 30/09/2013 21:15 And clicking Format > Number > Date time now immediately turns the cell into a date time cell (you can see this as it adds seconds).


1

With the following formula you can construct a month table, containing all days of the month. Formula =ARRAYFORMULA( DATE( YEAR(NOW()), // first A1, // second ROW( // ...


1

This is not a per-site setting, but a user setting (as a user of Sites). Follow these instructions to change your time-zone preference: Go to http://sites.google.com (where you see the list of your sites) Click on the settings (cog) button and choose 'User settings'. The User settings page has a dropdown for choosing your time-zone. Change it to 'Central'. ...



Only top voted, non community-wiki answers of a minimum length are eligible