Tag Info

Hot answers tagged

12

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.


11

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


9

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.


8

It’s possible to insert todays date through a macro. Open your Google Document and under Extra select Scripteditor. 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 ...


6

In Google just do the search as normal and select More search tools and Custom range in the sidebar and type in 1/1/2005 into the To:-field and click Search.


6

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 ...


5

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 ...


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

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


4

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


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

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

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

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

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

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 ...


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

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


1

I believe that the only way to achieve this is to set a locale in which this date format is a default one. For example I have it as default because I have Polish locale. Link to settings: https://drive.google.com/settings


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.


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

The following custom function will transform the string date notation into a date notation: Code function myDate(range) { var output = []; for(var i=0, iLen=range.length; i<iLen; i++) { var rSplit = range[i][0].split(" "), corr = 0; if(rSplit[4].substring(5,7) == "PM") { corr = 10; } var month = parseInt(new ...


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'. ...


1

With New Google Sheets please try Custom formula is: =today()-a1>7 with Background red and Range: to suit =and(A1-today()>0,A1-today()<28) with Background green and same Range: =A1-today()>=28 with Background white and same Range:


1

I don't know if there's a way to do that, except by writing some scripts (which can get pretty complex and probably not so reliable) There's a simpler workaround, though. You could: add a new column to the table, next to the date store the difference (in days) between that date and today (for example, if the date cell in the first row is C2, you could ...


1

The mistake is that you don't select both first and second sell (click and hover over both). When both are selected (both are highlighted), then drag the blue dot of the lower cell (like in Excel).


1

I tried Ctrl+; and it shows the local date (and time with Ctrl+Shift+;) so the issue appears to be fixed.



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